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

182 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
clustery1331711(None) 
blustery13368001blustery
cluster94013331cluster_
clusters102912401clusters
cluttery13346321cluttery
blistery13418712blistery
bluster94215312bluster_
blusters104413892blusters
cautery12349592cau_tery
clattery13378192clattery
clustered12186612clustered
clutter94211662clutter_
clutters103210352clutters
clyster12317452clyster_
clysters13227842clysters
fluster103913062fluster_
flusters113811502flusters
fluttery14376142fluttery
luster64023672_luster_
lusters73921442_lusters
plastery13279702plastery
adultery1244223adultery
allostery1243723allostery
austere7312993_austere
baluster1037053baluster_
balusters1136643balusters
blaster94017303blaster_
blasters104116143blasters
blister94415313blister_
blisters104015083blisters
blubbery14294783blubbery
blunter94512033blunter_
blurter9419833blurter_
blurters10348373blurters
blusher124113113blusher_
blushers133911293blushers
blustered12157263blustered
blusterer11176293blusterer
buster84726493_buster_
busters94724133_busters
buttery124311193_buttery
caster85232573c_aster_
casters94729903c_asters
cattery123811603c_attery
causer84117783caus_er_
causers94014793caus_ers
causey113513273caus_e_y
cemetery1554923cemetery
chastely1635813chastely
chaster124718503chaster_
chattery16357273chattery
chunter123911483chunter_
chunters133910903chunters
cistern93310703c_istern
clasher124615513clasher_
clashers134213993clashers
clasper113811863clasper_
claspers124410913claspers
classer93614613classer_
classers104111833classers
clatter94014973clatter_
clatters103313913clatters
claustra1043523claust_ra
cloister1037093cloister_
cloisters1137433cloisters
closely1237053clos_ely
closer84918203clos_er_
closers94415323clos_ers
clouter93511693clouter_
clouters10399803clouters
clovery15407403cl_overy
clownery1633313clownery
clubber13319593clubber_
clubbers14378583clubbers
clumber134011443clumber_
clumbers143910413clumbers
clumsier1234733clumsier_
clunker13419453clunker_
clunkers14327553clunkers
clustering13116813clustering
clutchy17323893clu_tchy
cluttered12185943cluttered
coaster94219043coaster_
coasters104317333coasters
corsetry1365573corsetry
coster84331293c_oster_
costers94128333c_osters
coulter94115603coulter_
coulters103614313coulters
counter94220153counter_
counters103320193counters
country12388043count_ry
courter94516483courter_
courters103015373courters
courtesy1364973courtesy
cousinry1343533cousinry
couter84930223cou_ter_
couters93827303cou_ters
crusher124412323crusher_
crushers134010093crushers
crusted103712753cruste_d
crustier10259533crustier_
crustily13328173crustily
crusty114911343crust__y
curter85320083c_urter_
curtesy1265833c_urtesy
cusser86016093c_usser_
cussers94213403c_ussers
custard10389973c_ustard
custardy14314903c_ustardy
custody1334093c_ustody
cutely115312803c_u_tely
cuter74728233c_u_ter_
cutesy114810733c_u_tesy
cutey105819793c_u_te_y
cutlery12448393c_utlery
cutter84521003c_utter_
cutters94218963c_utters
deluster936903deluster_
delusters1035983delusters
duster74919723_duster_
dusters84918363_dusters
elusory1083993elus_ory
flattery14338293flattery
flummery1833053flummery
flusher133012273flusher_
flushers14279733flushers
flustered13185883flustered
fluter95316863flu_ter_
fluters103713683flu_ters
flutey125212523flu_te_y
flutter104012093flutter_
flutters114010823flutters
glister84013343glister_
glisters93912603glisters
glittery12375613glittery
guttery11427763_guttery
jouster143311043jouster_
jousters153210423jousters
juster134617013_juster_
justers143815733_justers
klister113410643klister_
klisters123910483klisters
laster64830633_laster_
lasters75627693_lasters
lister64527253_lister_
listers74026533_listers
littery103710493_littery
lottery10389833_lottery
lusher93818763_lusher_
lusted74319443_luste_d
lustered92510603_lustered
lustier73813503_lustier_
lustily103611243_lustily
lustra6358893_lust_ra
lustre64011683_lust_re
lustred8359053_lustred
lustres73013233_lustres
lusty85417573_lust__y
mastery124214323_mastery
muster84724523_muster_
musters94522513_musters
mystery15436523_mystery
oldster896573oldster_
oldsters996733oldsters
ouster64223733_ouster_
ousters74122793_ousters
plaster93318693plaster_
plasters103518133plasters
plumbery17315533plumbery
plusher124010383plusher_
rouster73517083rouster_
rousters84315683rousters
slumbery15296043slumbery
spluttery14293623spluttery
sputtery13366473sputtery
truster73114313truster_
trusters83112263trusters
tushery1335633_tushery
ulster63712103ul_ster_
ulsters72711983ul_sters
wastery134610993_wastery

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621827.21620255.3
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.73223110.6
 
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.