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

117 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
clustered1218661(None) 
blustered12157261blustered
cluttered12185941cluttered
flustered13185881flustered
lustered92510601_lustered
blistered12167682blistered
blusterer11176292blusterer
chuntered1536662chuntered
clattered12178402clattered
cloistered1344512cloistered
cluster94013332cluster__
clusters102912402cluster_s
clustery13317112cluster_y
countered12313002countered
delustered1243292delustered
fluttered13185942fluttered
glistered11176292glistered
lustred8359052_lust_red
mustered112511502_mustered
plastered1288892plastered
altered83215733al__tered
austere7312993_austere_
austerer838383_austerer
bistered112913323_bistered
blattered12198563blattered
blubbered13164113blubbered
blundered1335193blundered
bluster94215313bluster__
blusterers12174993blusterers
blusters104413893bluster_s
blustery13368003bluster_y
bolstered1246093bolstered
buttered112712623_buttered
cantered113415983c_antered
catered103117773c__atered
centered112513523c_entered
chaptered17176793chaptered
chartered15158393chartered
chastened1545883chastened
chattered15197993chattered
chittered15166413chittered
clabbered16184763clabbered
clambered16146133clambered
clatterer11186983clatterer
clavered14187633cl_avered
clinkered1634773clinkered
clobbered16164103clobbered
closeted1135613clos_eted
closured11266353clos_ured
clotured11246163cl_otured
clovered14187363cl_overed
clustering13116813clustering
clutched16356033clu_tched
clutter94211663clutter__
clutters103210353clutter_s
cluttery13346323clutter_y
clyster12317453clyster__
clysters13227843clyster_s
coshered14610293c_oshered
cottered112511733c_ottered
cratered1149683c_ratered
crusted103712753crust__ed
cultured1137233c_ultured
cumbered15157963c_umbered
custard10389973c_ustar_d
festered122512103_festered
flattered13188623flattered
flittered13196253flittered
fluster103913063fluster__
flusteredly185813flusteredly
flusters113811503fluster_s
flutterer12185263flutterer
fostered122210453_fostered
glistened11174283glistened
glittered11195403glittered
guttered10259163_guttered
holstered1345883holstered
leistered1037043leistered
lettered92910783_lettered
listened9168813_listened
littered92511383_littered
lobstered1244643lobstered
loitered938183_loitered
lumbered13188233_lumbered
lusted74319443_lust__ed
luster64023673_luster__
lusters73921443_luster_s
lustre64011683_lust_re_
lustres73013233_lust_res
mastered112614003_mastered
muttered112610793_muttered
neutered937423neu_tered
oystered1236923_oystered
pestered112814963_pestered
plaistered1344133plaistered
plasterer1178103plasterer
plundered1344313plundered
puttered112611143_puttered
reuttered1036073reuttered
roistered1037643roistered
roystered1344873roystered
sauntered1036283sauntered
scuttered12166423scuttered
shuttered13156333shuttered
sistered92612803_sistered
slubbered14175253slubbered
slumbered14215593slumbered
spluttered13153173spluttered
sputtered12166323sputtered
stuttered10145763stuttered
subclustered1751223subclustered
trusteed9346533truste_ed
uncluttered1451913uncluttered
unuttered1065733unuttered
ushered1139153__ushered
uttered82712433__uttered
westered122511863_westered

Search took 9 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.843211970.3
2DLD Change Limit1486411177.20320636.0
3Display Results1171170.1101063.6
 (SQL Overall)1786911178.15621909.1
 
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.