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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
smoulders124314(None) 
moulders11348341_moulders
shoulders1334231shoulders
smolders11287191smo_lders
smoulder1133441smoulder_
boulders113010032_boulders
molders103315552_mo_lders
moulder10389802_moulder_
moulters103510782_moulters
scolders11288992sco_lders
shoulder1234752shoulder_
smolder10327752smo_lder_
smouldered1441962smouldered
solders83517772s_o_lders
sounders93214112s_ounders
boulder103411343_boulder_
bouldery14295013_bouldery
bounders114314113_bounders
bowlders14306493_bowlders
coulters103614313_coulters
flounders1374613flounders
folders113514393_fo_lders
founders123911673_founders
grounders1156783grounders
holders113715903_ho_lders
hounders123111713_hounders
impounders1542983impounders
maulers94213303_maul_ers
maunders11348343_maunders
melders103213913_m_elders
moilers93615203_moil_ers
molder93819273_mo_lder_
molters93816973_mo_lters
moulded11348063_moulde_d
mouldered1343753_mouldered
mouldier1154963_mouldier_
moulds94910993_mould__s
moulter93812423_moulter_
mounters103712503_mounters
mourners1036913_mourners
mousers95216443_mou_sers
mouthers133811303_mouthers
mudders113211113_m_udders
mullers93217303_m_ullers
murders103311363_m_urders
polders103617373_po_lders
poulters103911053_poulters
pounders113113283_pounders
rounders92613693_rounders
scolder103210343sco_lder_
scourers10348533scou_rers
scourgers1234383scourgers
scouters103411323scou_ters
scouthers1445993scouthers
scowders14276233sco_wders
scowlers13257373scowl_ers
sculkers14306933s_culkers
scullers103510483s_cullers
shielders1334763shielders
shouldered1542233shouldered
shouldest1344143shouldest
shouters113510623shou_ters
shudders13316643s_hudders
skulkers11334923s_kulkers
slouchers14185623slouchers
smellers10329773sm_ellers
smelters103310513sm_elters
smilers94113853sm_il_ers
smogless1134053smogl_ess
smokers13389323smo__kers
smoldered1343793smo_ldered
smoochers16184833smoochers
smoothers14206043smoothers
smothers13349933smo_thers
smouldering1572173smouldering
solder73921343s_o_lder_
soldiers9277773s_o_ldiers
solvers104414253s_o_lvers
sonders83820713s_o_nders
soulless8218763s_oulless
sounder83315383s_ounder_
souters74422603s_ou_ters
southers114214453s_outhers
spoilers10238633spoil_ers
spoolers10349363spool_ers
spouters104011163spou_ters
spudders12255633s_pudders
sulkers113613343s__ulkers
sunders84120053s__unders

Search took 7 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 Filter1786911486410.440406115.9
2DLD Change Limit148641896.32623496.8
3Display Results89890.0332697.0
 (SQL Overall)178691896.79926282.0
 
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.