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

139 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
flatterer1218767(None) 
clatterer11186981clatterer
flattener12175171flattener
flattered13188621flattered
flatterers13175911flatterers
flutterer12185261flutterer
batterer102713212_batterer
blatherer14176712blatherer
blattered12198562blattered
chatterer14196842chatterer
clattered12178402clattered
clatterers12155422clatterers
falterer11239852f_alterer
fattener11268112f_attener
fetterer11207812f_etterer
flattened13185302flattened
flatteners13164152flatteners
flatter103815962flatt__er
flatteries1347412flatteries
flatters113814202flatter_s
flattery14338292flatter_y
flittered13196252flittered
fluttered13185942fluttered
flutterers13184592flutterers
fritterer12234402fritterer
latherer111310442_latherer
letterer8259222_letterer
litterer82810172_litterer
patterer103112172_patterer
plasterer1178102plasterer
scatterer11186292scatterer
shatterer12177202shatterer
smatterer11185812smatterer
alterer72713993__alterer
banterer102811773_banterer
barterer102711633_barterer
battener10369393_battener
battered113315053_battered
batterers113110713_batterers
bitterer10309773_bitterer
blathered15168353blathered
blatherers15175343blatherers
blatter94415653blatt__er
blatters104414093blatter_s
blusterer11176293blusterer
caterer92815943_ca_terer
charterer14197323charterer
chattered15197993chattered
chatterers15205463chatterers
clamberer15185273clamberer
clatter94014973clatt__er
clatters103313913clatter_s
clattery13378193clatter_y
cluttered12185943cluttered
faltered122810983f_altered
falterers12238033f_alterers
fastener11227833f_astener
fathered151510433f_athered
fattened12268283f_attened
fatteners12236873f_atteners
fatter94523213f_att__er
fattier103513463f_att_ier
feathered16188893feathered
featherier1645803featherier
fettered12259493f_ettered
fetterers12267043f_etterers
filterer11258143f_ilterer
flatfeet1446213flatfe_et
flatliner12285383flatliner
flatted114012943flatt__ed
flatten10429653flatt__en
flattens11357483flatte_ns
flattering1498743flattering
flattest1138713flatte_st
flatware1444883flatware_
flatwares1544763flatwares
flavorer1454553fla_vorer
flitter103413903flitt__er
flitters114312173flitter_s
flowerer1435453fl_owerer
flustered13185883flustered
flutter104012093flutt__er
flutters114010823flutter_s
fluttery14376143flutter_y
fosterer11239523f_osterer
fracturer14134623fracturer
frittered13205163frittered
fritterers13203393fritterers
fruiterer1243333fruiterer
furtherer1543813furtherer
gatherer12147903_gatherer
glittered11195403glittered
lateener835763_lateener
lathered121512323_lathered
latherers12158853_latherers
latter65027893_latt__er
latterly1136063_latterly
lettered92910783_lettered
letterers9228113_letterers
littered92511383_littered
litterers9228193_litterers
loiterer837083_loiterer
mattered112412903_mattered
mutterer10218913_mutterer
nattered92011623_nattered
palterer102411273_palterer
pattered112714203_pattered
patterers112410123_patterers
plastered1288893plastered
plasterers1286123plasterers
platter93917413platt__er
platters103415283platter_s
potterer102310263_potterer
putterer10209913_putterer
quarterer18145713quarterer
rattener8238533_rattener
scattered12197353scattered
scatterers12205043scatterers
shattered13178203shattered
shatterers13185723shatterers
slanderer1046673slanderer
slathered13148543slathered
slattern837093slatter_n
slatterns935363slatterns
slaverer11196993sla_verer
smattered12186783smattered
smatterers12174873smatterers
spattered12187643spattered
splattered13163933splattered
splutterer12132743splutterer
sputterer11165263sputterer
stutterer9164913stutterer
tattered92011443_tattered
titterer8268523_titterer
totterer8217793_totterer
twitterer1243303twitterer
utterer71910463__utterer
waterer103314073_wa_terer
yattered12239533_yattered

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.406440125.6
2DLD Change Limit1486411396.14024208.6
3Display Results1391390.0632206.3
 (SQL Overall)1786911396.60927037.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.