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

102 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
udon5601774(None) 
don46757651_don
udo49027301udo_
udons65411461udons
udos56619901udos
upon65817581upon
ado49146872ado_
adorn64917092adorn
ados57633512ados
adown95611662adown
aeon45634612aeon
agon56531882agon
anon46134852anon
axon115524302axon
azon135725052azon
boon67142172boon
chon96627792chon
cion613330912cion
clon66232482clon
codon86522852codon
con510268022_con
coon67248942coon
dan46859662_dan
den47554342_den
din46459462_din
do310155252_do_
doc66841512_doc
doe47361952_doe
dog57449752_dog
dol47150652_dol
dom69752442_dom
dona55529632_dona
done55747912_done
dong66031652_dong
dons56048702_dons
dor47253922_dor
dos48062312_dos
dot47573182_dot
dow76749972_dow
down86427492_down
dun46545582_dun
duo48536142duo_
duos56728132duos
durn56127622durn
ebon66821102ebon
eon36052082_eon
exon117116802exon
fon66352272_fon
futon83113772futon
goon57236172goon
guidon837372guidon
hon67759382_hon
icon66922042icon
idol56818632idol
ikon85814952ikon
ion36051022_ion
iron46728462iron
jeon116821442jeon
judo125315302judo_
judos134711732judos
jupon14479192jupon
kaon87521022kaon
kudo96115102kudo_
kudos105011252kudos
lion46334442lion
loon47344792loon
mon57561572_mon
moon67140812moon
muon65722732muon
muton73817002muton
neon47026422neon
noon47134622noon
odeon6411482odeon
odor55718092odor
on28057182__on
peon65635242peon
phon95925382phon
pion67235292pion
poon67341262poon
puton73617912puton
radon64620502radon
redon65424882redon
son37761952_son
soon46240502soon
sudor6312622sudor
ton310265102_ton
toon47740632toon
ulan46527392ulan
un28341132u__n
undo55620152undo_
undone7914252undone
union54519792union
unwon84512342unwon
updo76712882updo_
updos8389512updos
upo58925862upo_
urn35731462u_rn
voudon1035872voudon
won66252062_won
yon67348952_yon
yupon10469482yupon
zoon137326982zoon

Search took 1 second 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.0762351197.4
2DLD Change Limit298721020.87634100.5
3Display Results1021020.0137846.2
 (SQL Overall)1786911020.965185172.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.