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 “viol” with Change Limit: [1] [2]

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

141 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
viol7652359(None) 
diol57329131diol
vial76731091vial
vill75235071vill
viola85915541viola
viols86118101viols
virl76224471virl
ail37171042ai_l
aioli5318312aioli
avion84218342avion
awol75620672awol
bill67239942bill
bio57846082bio_
biog76122322biog
bios66335322bios
birl65830472birl
boil66335182boil
cibol9512022cibol
cion613330912cion
coil66439652coil
col59360352_col
cool66940492cool
dial55935062dial
diel59034602diel
dill55239972dill
diols65521012diols
dirl57430022dirl
dol47150652_dol
enol45823822enol
evil75318072evi_l
fil65447142fi_l
fill75540192fill
filo76034282filo
foil76433912foil
fool75330592fool
gaol56925412gaol
gill56336182gill
girl56226552girl
hill76439492hill
idol56818632idol
ill37437092_ill
ion36051022_ion
jill116430262jill
kill85533182kill
kilo86028672kilo
lilo46731562lilo
lion46334442lion
mil55752112mi_l
mill66541482mill
milo65536102milo
moil65534092moil
mol56654592_mol
mool67533862mool
nicol71113292nicol
nil36144192ni_l
nill45634302nill
noil46133242noil
obol65220612obol
oil37452052oi_l
pial65636702pial
pill65339462pill
pion67235292pion
pol56449382_pol
pool65835952pool
rial45938092rial
riel46432382riel
rill45140902rill
riot45947212riot
roil46235292roil
sial45938832sial
sill45545152sill
silo46037912silo
soil46138832soil
sol37256622_sol
thiol87616042thiol
til36350262ti_l
till45941202till
tirl45029922tirl
toil46536282toil
tool46735682tool
triol55521362triol
vail75432552vail
veal76936812veal
veil75523592veil
via65636242vi_a
vials85822382vials
vibe95124502vibe
vice95732852vice
vid77241812vi_d
vide85432762vide
vids85627542vids
vie65447632vi_e
vied86328632vied
vier75428152vier
vies75238622vies
view105917672view
vig75637522vi_g
viga85622962viga
vigil94313002vigil
vigor92612422vigor
vigs85427272vigs
vile76139802vile
villa85321232villa
villi86517852villi
vills86429322vills
vim87437022vi_m
vims95423312vims
vina76331802vina
vinal85725812vinal
vine75643682vine
vino76128432vino
vinos84723072vinos
viny106025952viny
vinyl115311622vinyl
violas93713522violas
violet92620922violet
violin9311982violin
viral86419592viral
virls85618602virls
vis66747612vi_s
visa76323872visa
vise75632672vise
visor82512832visor
vita75828522vita
vital84819672vital
viva106119092viva
vive105426622vive
vizor173010092vizor
voe67739052v_oe
void86220562void
voila84813942voila
voile84719722voile
vole75236982v_ole
volt76439532v_olt
vow96136312v_ow
vox136628152v_ox
vrow105817472vrow
will75737512will
wool76427372wool
yill75628972yill
zill135727612zill

Search took 2 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 Filter178691298720.263679433.5
2DLD Change Limit298721410.75039829.3
3Display Results1411410.0463065.2
 (SQL Overall)1786911411.059168735.6
 
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.