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

112 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
sputterer1116526(None) 
putterer10209911_putterer
splutterer12132741splutterer
sputtered12166321sputtered
sputterers12174581sputterers
stutterer9164911stutterer
flutterer12185262flutterer
mutterer10218912_mutterer
patterer103112172_patterer
potterer102310262_potterer
puttered112611142_puttered
putterers11238362_putterers
saunterer945032saunterer
scatterer11186292scatterer
scuttered12166422scuttered
shatterer12177202shatterer
shuttered13156332shuttered
smatterer11185812smatterer
spattered12187642spattered
spluttered13153172spluttered
splutterers13142162splutterers
sputter94014052sputt__er
sputters104012872sputter_s
sputtery13366472sputter_y
stuttered10145762stuttered
stutterers10164302stutterers
utterer71910462__utterer
adulterer1043553adulterer
austerer838383_austerer
batterer102713213_batterer
bitterer10309773_bitterer
blusterer11176293blusterer
buttered112712623_buttered
butterier1177453_butterier
chatterer14196843chatterer
clatterer11186983clatterer
cluttered12185943cluttered
fetterer11207813_fetterer
flatterer12187673flatterer
fluttered13185943fluttered
flutterers13184593flutterers
fritterer12234403fritterer
fruiterer1243333fruiterer
guttered10259163_guttered
letterer8259223_letterer
litterer82810173_litterer
muttered112610793_muttered
mutterers11247373_mutterers
palterer102411273_palterer
pattered112714203_pattered
patterers112410123_patterers
pesterer102412703_pesterer
pewterer13256313_pewterer
pottered112311663_pottered
potterers11218663_potterers
poulterer1145423poulterer
puckerer1645793_puckerer
puttee85919723_putte_e_
puttees93612913_putte_es
putter83921443_putt__er
putters94219193_putter_s
puttier93314503_putt_ier
reuttered1036073reuttered
sauntered1036283sauntered
saunterers1044383saunterers
scattered12197353scattered
scatterers12205043scatterers
scutter93512173scutt__er
scutters103311023scutter_s
shattered13178203shattered
shatterers13185723shatterers
shelterer1245033shelterer
shutter103712143shutt__er
shutters113611353shutter_s
shuttler1164903shutt_ler
skittered1434633skittered
skitterier1442423skitterier
slumberer13194803slumberer
sluttier836453slutt_ier
smattered12186783smattered
smatterers12174873smatterers
smotherer1444633smotherer
smuttier1035213smutt_ier
spatter94016523spatt__er
spatters103914703spatter_s
spitter94015183spitt__er
spitters104113383spitter_s
splattered13163933splattered
splutter10357443splutt__er
splutters11286273splutter_s
spluttery14293623splutter_y
spotter94514883spott__er
spotters104313383spotter_s
spottier10207313spott_ier
spurrer93710223spu__rrer
spurter94013003spurt__er
spurters103311703spurter_s
sputtering13106463sputtering
squattered2043253squattered
steerer73113633s__teerer
stutter72911463stutt__er
stutters83210473stutter_s
sufferer1436063s_ufferer
sunderer9310523s_underer
suttee63721543s_utte_e_
suttees74114063s_utte_es
titterer8268523_titterer
totterer8217793_totterer
twitterer1243303twitterer
unuttered1065733unuttered
uttered82712433__uttered
utterers8218653__utterers

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411127.20320636.0
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.67223291.3
 
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.