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

146 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
solitons84959(None) 
solions7513751soli_ons
soliton7410231soliton_
silicons10107162silicons
solations9814622solations
solion6616382soli_on_
solons65120022sol__ons
solutions988882solutions
volitions1288662volitions
abolitions1246653abolitions
bolsons969483bol_sons
bonitoes1038153bonitoes
bonitos939733bonito_s
bostons9312903bo_stons
boutons9310783bo_utons
chitons122611913_chitons
coalitions1247923coalitions
cogitos1037613cogito_s
coitions10312853co_itions
colicins12312853colicins
colins85229043coli__ns
colistins1149223colistins
colitis92617353colit_is
colons86028683col__ons
cottons9312193co_ttons
daltons8310403dal_tons
eoliths10318573eolit_hs
excitons1746043excitons
foisons1047613fo_isons
foliations1399943foliations
folios93915463foli_o_s
folious103710733foli_ous
goldtone1084603goldtone
helicons1337613helicons
horizons2045463horizons
iolites73819483iolit_es
isolations10310693isolations
isolators947513isolators
kilotons1286313kilotons
lions55923213__li_ons
logions86211293logi_ons
lotions74614763loti_ons
malisons1048783malisons
meltons9410923mel_tons
mirlitons1144113mirlitons
monitions11310883monitions
monitors10310823monitors
morions94014643mori_ons
motions94215003moti_ons
moutons9410313mo_utons
nitons64614903__nitons
notions74014483noti_ons
olios54520853_oli_o_s
onions64016433_oni_ons
oolites72817843oolit_es
ooliths10268323oolit_hs
options93810603_options
orisons7310563_orisons
pelotons1038913pelotons
pitons85319043__pitons
plutons938343_plutons
poisons9310353po_isons
polarons1039863polarons
polios84019723poli_o_s
politics122513813politics
polities102722343polities
polygons1447723polygons
pontons93315553po_ntons
portions10514413portions
positions11811503positions
positrons1186543positrons
potions93417423poti_ons
ronions73313343roni_ons
sabatons1037843sabatons
sacatons1038973sacatons
sadirons936023sadirons
salicins10310933salicins
salmons93713263sal_mons
salons63823693sal__ons
saloons74415323sal_oons
scions82612243s_ci_ons
sections102714703sections
seditions1039013seditions
seitans73312303s_eitans
semitone1048973semitone
semitones1148943semitones
setons64620173s__etons
sextons143710413s_extons
shaitans1136413shaitans
sheitans1155603sheitans
silicon9117533silicon_
silicone1096733silicone
silicones11106553silicones
skeletons1343933skeletons
slits56128853s_lit__s
softens10347623so_ftens
solanins8310513solanins
solanos74412853solano_s
solans64122493sol__ans
solates73523853solat_es
solating9315593solating
solation8916153solation_
soldans83210403sol_dans
solicitors1244213solicitors
solicitous1244173solicitous
solicits10311023solicits
solids74116403soli__ds
solidus8338113soli_dus
soling74226823soli__ng
solitary1146503solitary
solitude9105053solitude
solitudes10105013solitudes
solon55026133sol__on_
solos54830793sol__o_s
solutes73515263solut_es
solution889593solution_
solvations1336833solvations
somites94219123somit_es
sopites93817173sopit_es
sopiting11310763sopiting
sorbitols1142923sorbitols
sorites73825243sorit_es
sorptions1137123sorptions
sortitions1046423sortitions
sotols63714473so__tols
soupcons1244373soupcons
sozins15510793sozi__ns
splits85416413split__s
spoliations1347693spoliations
spoliators1244823spoliators
stations82415223stations
stolons73410243stol__ons
suctions103012903suctions
suitors73012493s_uitors
sultans72411833sul_tans
talions7314113tali_ons
tolidins948023tolidins
tritons73814883_tritons
volitant1147863volitant
volition1179173volition_
volutins1188003volutins
volutions12108393volutions
vomitos12217103vomito_s
vomitous13215803vomitous
wontons103310533wo_ntons
xylitols1841753xylitols

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621467.45019619.1
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.93622516.5
 
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.