Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “oilways” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
oilways133487(None) 
oilway1235741oilway_
airways1336242airways
always12409132_always
midways16386182midways
oilcans936812oilcans
onlays9398712onl_ays
railways1444602railways
rollways1444232rollways
tollways1444132tollways
airway1237693airway_
aisleways1542103aisleways
allays94313743_allays
alway116113923_alway_
anyways1644423anyways
belays114313853bel_ays
beltways1683903beltways
bikeways2043653bikeways
byways1734673_byways
clays105521333_cl_ays
cogways1634633cogways
cullays12347703cullays
delays104014053del_ays
dismays13237433dismays
diwans105110373di_wans
doorways1544043doorways
endways1444443endways
fairways1743873fairways
fishways2043643fishways
flays116321053_fl_ays
flyways19133853flyways
folkways2143143folkways
foodways1844293foodways
footways1744873footways
hallways1745423hallways
highways2144123highways
holidays1544103holidays
iliads7448673_iliads
inlays9389873_inlays
jetways2094053jetways
keyways2043373keyways
lays76043253__l_ays
leeways1354453leeways
lifeways1743893lifeways
lilacs837483lil_acs
logways1434513logways
longways1543873longways
middays14335663middays
midway15327153midway_
milpas101710273milpa_s
mislays12349243mislays
missays124010253missays
nilgais845203nilgais
nilgaus844003nilgaus
noways12127733_noways
ofays11488923o__fays
oilcamp1343053oilcamp
oilcamps1442163oilcamps
oilcan837793oilca_n
oilcups1143333oilcups
oilers64721193oil_ers
oilily93111723oilily_
oilman839483oilma_n
oils46337973oil___s
oily77932253oil__y_
okays12609443o__kays
ollas54218283o_lla_s
onlay84212943onl_ay_
onloads8246673onloads
orfrays1343533orfrays
outlays102610903outlays
outsays102710403outsays
outwars10912793outwars
paleways1645833paleways
pilafs113511023pil_afs
pilaus84114133pil_aus
pilaws11399433pil_aws
pillars9313493pillars
plays106320773_pl_ays
railway1345313railway_
relays94316753rel_ays
roadways1564613roadways
rollaways1542593rollaways
rollway1344653rollway_
ropeways1644053ropeways
runways13134443runways
seaways13307513seaways
shipways1944073shipways
sideways1545233sideways
silvans10308333silvans
silvas92912183silva_s
skidways1942823skidways
skyways2043223skyways
slays85723683_sl_ays
slipways1643463slipways
someways1644823someways
spillways1742253spillways
splays114910873spl_ays
subways1536163subways
sways115518463__sways
tideways1544563tideways
tilaks1097353til_aks
tollway1344793tollway_
towaways1743633towaways
unlays93810493unl_ays
villas96117263villa_s
walkways2143213walkways
ways107737953___ways
wigwags1543293wigwags
wigwams1643883wigwams
windways1845043windways
wireways1745833wireways
zillahs1935383zillahs

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.406440125.6
2DLD Change Limit1340271136.48620664.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.93825755.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.