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 “oilway” 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.

182 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
oilway123574(None) 
oilways1334871oilways
airway1237692airway
alway116113922_alway
midway15327152midway
oilcan837792oilcan
oilily93111722oilily
oilman839482oilman
oily77932252oil__y
onlay84212942onl_ay
railway1345312railway
rollway1344652rollway
tollway1344792tollway
airways1336243airways
aisleway1442523aisleway
allay85620393_allay
always12409133_always
anyway1534803anyway
away108024223__away
belay105021523bel_ay
beltway1564373beltway
bikeway1944313bikeway
bilby124912353bil_by
bilgy114713713bil_gy
biliary1238213biliary
billy105525363bil_ly
byway1647533_byway
cilia73016763cilia_
ciliary1247923ciliary
clay95927413_cl_ay
cogway1566183cogway
cullay113910173cullay
delay94820633del_ay
dilly94923783dil_ly
dismay12229473dismay
diwan95712553di_wan
doily95321033doil__y
doorway1444243doorway
fairway1644333fairway
fila74729133fil_a_
filar84819293fil_ar
filial93013253filial
filly114424903fil_ly
filmy136114043fil_my
filthy15356423filthy
fishway1943813fishway
flawy145913383_flawy
flay106332803_fl_ay
flyway18134693flyway
folkway2043353folkway
footway1635253footway
gilly94321633gil_ly
halfway1943763halfway
hallway1636173hallway
highway2044263highway
hila76228353hil_a_
hilar85418143hil_ar
hilly114422163hil_ly
holiday1436143holiday
ilea45931463_ilea_
ileac75814173_ileac
ileal56118083_ileal
ilia46026823_ilia_
iliac75013493_iliac
iliad64613463_iliad
ilial55317843_ilial
ilka87215153_ilka_
illy76925333_il_ly
inlay85214323_inlay
jetway19105273jetway
keyway1943823keyway
kilty125213893kil_ty
lay68865353__l_ay
leeway1255883leeway
lifeway1644273lifeway
lilac7311073lil_ac
lily76730183lil__y
logway1335913logway
midday13327503midday
midways16386183midways
milady1236613milady
mildly12318243mildly
milia72719573milia_
miliary1249463miliary
milky144014443mil_ky
milpa92111403milpa_
milpas101710273milpas
milty104720073mil_ty
mislay113510683mislay
missay114112143missay
nilgai734883nilgai
nilgau735113nilgau
noily86120993noil__y
noway111112843_noway
ofay106416103o__fay
oidia6314953oidia_
oil37452053oil___
oilcamp1343053oilcamp
oilcans936813oilcans
oilcup1044253oilcup
oiled64429473oil_ed
oiler54628283oil_er
oilers64721193oilers
oilier64417233oilier
oiling74925313oiling
oilmen848313oilmen
oils46337973oil__s
okay115917663o__kay
oldy85316843o_l_dy
olea46532723o_lea_
olivary1345163olivary
olla44821173o_lla_
ollas54218283o_llas
ology94113113o_logy
onlays9398713onl_ays
onload7268633onload
only75319723onl__y
oology103210253oology
orfray1234393orfray
outlay92711793outlay
outsay92611873outsay
outwar91011513outwar
pilaf103923483pil_af
pilar75221503pil_ar
pilau73618523pil_au
pilaw103913743pil_aw
pilaws11399433pilaws
pilea75123953pilea_
pillar8314023pillar
pily96132733pil__y
play95928983_pl_ay
railways1444603railways
relay84424673rel_ay
riley84420583ril_ey
roadway1464613roadway
roily86121113roil__y
rollaway1443263rollaway
rollways1444233rollways
ropeway1544773ropeway
runway12105973runway
seaway12309993seaway
shipway1844213shipway
sideway1445673sideway
silky125315823sil_ky
silly84527623sil_ly
silty84721633sil_ty
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
skidway1843083skidway
skyway1933343skyway
slay76436383_sl_ay
slipway1543873slipway
someway1545613someway
spillway1642763spillway
splay105816043spl_ay
subway1447073subway
sway107128233__sway
tideway1445153tideway
tilak91011553til_ak
tollways1444133tollways
towaway1644153towaway
unlay84613703unl_ay
viewy14518103view_y
vilely1239443vilely
vilify1536773vilify
villa85321233villa_
villae95615383villae
villas96117263villas
voila84813943voil_a_
walkway2043373walkway
way96757663___way
wigwag1443723wigwag
wigwam1544723wigwam
wildly13328123wildly
wilily123310763wilily
willy115321913wil_ly
wily106428813wil__y
windway1745153windway
wireway1646043wireway
zillah1836563zillah

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161824.87323130.7
3Display Results1821820.0463956.5
 (SQL Overall)1786911825.05935321.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.