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

145 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
elite5623018(None) 
blite76225351blite
elate55335881elate
elide64922641elide
elites66027121elites
elute54822571elute
evite85317681evite
flite85424961flite
lite47054541_lite
pelite84323001pelite
alate55340332alate
albite8313312albite
alike95523962alike
aline57243152aline
alit46155692alit_
alive85722512alive
aplite8316392aplite
axite125218252axite
belie75630382beli_e
belike124616282belike
belive115415302belive
bite66547002_bite
blate75933782blate
blites84721212blites
blithe115810862blithe
blitz165318132blitz
boite74426322boite
cerite84724872cerite
cite65640342_cite
clime95720892clime
cline76428532cline
delate73827752delate
delete73620702delete
delime9314042delime
dite55547552_dite
edile64819492edile
edit54934862edit_
edited83913672edited
edits65819032edits
egalite8311562egalite
eide55832242e_ide
elated74725822elated
elater64724202elater
elates65032362elates
elided84814672elided
elides74420692elides
elint55436472elint
elints65816422elints
elope75219342elope
else45923082el_se
eluate62315432eluate
elude64517622elude
eluted74915262eluted
elutes64020312elutes
emit65438422emit_
emits75421472emits
emote75421192emote
enate54428152enate
endite73817592endite
eolith93013902eolith
evited104013142evited
evites94916472evites
excite15310882excite
exile126117652exile
exine125518492exine
exit114428672exit_
exited144712522exited
exits125515912exits
feline94820142feline
felsite1039082felsite
flit76539272flit_
flited104616582flited
flites95122442flites
flits85625222flits
flute86823752flute
flyte115713942flyte
gelate73421262gelate
gite55438612_gite
glide74521592glide
glime85620192glime
glitz154916372glitz
glute66020902glute
halite93624232halite
illite63414922illite
iolite63221982iolite
kite85338242_kite
late47560482_late
lenite6719982lenite
lice66045062_lice
lie38264522_li_e
life75433732_life
like86040842_like
lime66244932_lime
line46965572_line
lipe66839732_lipe
lire47845292_lire
lit39377312_lit_
liter54736342_liter
lithe84922012_lithe
litre55421462_litre
lits46252492_lits
litu47631562_litu
live76540992_live
lute46341012_lute
mite66249412_mite
nite45943582_nite
olive84817152olive
oolite63319602oolite
pelites93821992pelites
penlite9313242penlite
perlite9317322perlite
petite84320652petite
plate74635112plate
plie65127392pli_e
polite83625072polite
quite144621462quite
recite83625112recite
relate64033632relate
reline65434352reline
relit55340682relit_
relive95120782relive
resite64128452resite
rite45849452_rite
site47052412_site
skite95120052skite
slate55438282slate
slice74925822slice
slide64725412slide
slime74925752slime
slipe75626132slipe
slit46250102slit_
slits56128852slits
smite75224872smite
spite75430662spite
suite54829562suite
trite54730032trite
unite54828382unite
velate93720142velate
velites103417302velites
verite94323442verite
white114920302white
wite75443272_wite
write85522832write
zeolite1638902zeolite
zlote143912942zlote

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 Filter178691538000.360496363.9
2DLD Change Limit538001451.46636698.5
3Display Results1451450.0463152.2
 (SQL Overall)1786911451.87295454.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.