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

130 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
mutterers1124737(None) 
mutterer10218911mutterer_
putterers11238361putterers
utterers8218651_utterers
batterers113110712batterers
fetterers12267042fetterers
flutterers13184592flutterers
letterers9228112letterers
litterers9228192litterers
miterers10219682m_iterers
murderers1244592murderers
muttered112610792muttere_d
mutters94117142mutt__ers
patterers112410122patterers
potterers11218662potterers
putterer10209912putterer_
smatterers12174872smatterers
sputterers12174582sputterers
stutterers10164302stutterers
titterers9236992titterers
totterers9186812totterers
utterer71910462_utterer_
adulterers1143173adulterers
alterers82512493_alterers
austerer838383austerer_
banterers112410003banterers
barterers11269633barterers
batteners11238163batteners
batterer102713213batterer_
bitterer10309773bitterer_
blusterers12174993blusterers
butcherers1742703butcherers
butterburs1443153butterburs
buttered112712623buttere_d
butterier1177453butterier_
butteries11711763butteries
butterless1244193butterless
butters94521723butt__ers
buttoners1145703buttoners
buttress1035883butt_ress
caterers102814403_caterers
chatterers15205463chatterers
clatterers12155423clatterers
cumberers15176003cumberers
cutters94218963cutt__ers
ditherers13196683ditherers
dotterels1043903dotterels
enterers82214153_enterers
falterers12238033falterers
fatteners12236873fatteners
fetterer11207813fetterer_
filterers12206973filterers
flatterers13175913flatterers
flutterer12185263flutterer_
fosterers12238023fosterers
fritterers13203393fritterers
fruiterers1343003fruiterers
furtherers1643323furtherers
gatherers13156883gatherers
guttered10259163guttere_d
gutters83715513gutt__ers
guttlers9306933gutt_lers
latherers12158853latherers
letterer8259223letterer_
litterer82810173litterer_
loiterers936263loiterers
lumberers13196013lumberers
mattered112412903mattere_d
matters94421753matt__ers
mattress1036533matt_ress
maturers1037373m_aturers
maunderers1383753maunderers
miterer92511333m_iterer_
mottlers10388183mott_lers
muleteers1143673muleteers
multures1039333multure_s
murderees1244353murderees
murderer1145263murderer_
murderess1243593murderess
murmurers1342673murmurers
murthers1336543murt_hers
mustees94614923muste_e_s
mustered112511503mustere_d
musters94522513must__ers
muteness1039013mu_teness
mutineers1144633mutineers
mutter84418883mutt__er_
muttering122611323muttering
numberers13165153numberers
nurturers943353nurturers
nutters74215433nutt__ers
outsteers936033outste_ers
outtowers1244763outtowers
oysterers1245573oysterers
palterers11249533palterers
patterer103112173patterer_
pesterers112510453pesterers
pewterers14216043pewterers
potterer102310263potterer_
poulterers1244563poulterers
puckerers1744513puckerers
puttees93612913putte_e_s
puttered112611143puttere_d
putters94219193putt__ers
puttiers10288013putt_iers
quarterers19124823quarterers
quaverers2143853quaverers
quiverers2143713quiverers
ratteners9237263ratteners
saunterers1044383saunterers
scatterers12205043scatterers
shatterers13185723shatterers
smatterer11185813smatterer_
smotherers1543813smotherers
splutterers13142163splutterers
sputterer11165263sputterer_
steerers82511353_steerers
stutterer9164913stutterer_
sufferers1555103sufferers
sunderers1039073sunderers
suttees74114063sutte_e_s
titterer8268523titterer_
totterer8217793totterer_
twitterers1342673twitterers
uttered82712433_uttere_d
utterness946223_utterness
utters63817123_utt__ers
waterers112312783_waterers
winterers12209723winterers
witherers15146843witherers

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.420425454.8
2DLD Change Limit1486411306.33023482.0
3Display Results1301300.0602166.7
 (SQL Overall)1786911306.81026239.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.