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

256 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
clattery1337819(None) 
cattery123811601c_attery
chattery16357271chattery
clatter94014971clatter_
clatters103313911clatters
cluttery13346321cluttery
flattery14338291flattery
battery124911812_battery
blatter94415652blatter_
blatters104414092blatters
cautery12349592c_autery
chatter124416642chatter_
chatters134213952chatters
clattered12178412clattered
clatterer11186992clatterer
clustery13317112clustery
clutter94211662clutter_
clutters103210352clutters
flatter103815962flatter_
flatters113814202flatters
fluttery14376142fluttery
glittery12375612glittery
lathery133911122_lathery
latter65027892_latter_
latterly1136062_latterly
littery103710492_littery
lottery10389832_lottery
mattery123810712_mattery
plastery13279702plastery
platter93917412platter_
platters103415282platters
slattern837092slattern
artery9911453__artery
batter84928873_batter_
batters94626013_batters
bladdery15344583bladdery
blaster94017303blaster_
blasters104116143blasters
blather125314213blather_
blathers134713793blathers
blatted104812713blatte_d
blattered12198573blattered
blistery13418713blistery
blotter94612853blotter_
blotters104110983blotters
blustery13368003blustery
buttery124311193_buttery
cannery123610013c_annery
canter85230113c_anter_
canters94827733c_anters
carter84932273c_arter_
carters95327253c_arters
caster85232573c_aster_
casters94729903c_asters
cater74840723c_a_ter_
caters85336503c_a_ters
catted95422473c_atte_d
cattier93317073c_attier_
cattily123210853c_attily
catty104520413c_att__y
cemetery1554923cemetery
chancery18366653chancery
chanter123919733chanter_
chanters134016743chanters
chantey154112543chante_y
chantry15388223chant_ry
chapter144213853chapter_
chapters154012133chapters
charter123918303charter_
charters134115583charters
chastely1635813chastely
chaster124718503chaster_
chatted133411893chatte_d
chattel12388893chatte_l
chattels13286793chattels
chattered15197993chattered
chatterer14196843chatterer
chattier1337513chattier_
chattily1634603chattily
chatty14419363chatt__y
chitter124112963chitter_
chitters133711173chitters
citatory1347213citatory
cittern9339143c_ittern
clabber134210113clabber_
clabbers14359903clabbers
clacker153813773clacker_
clackers163911703clackers
claimer11279883claimer_
claimers12298743claimers
clamber133311743clamber_
clambers144211293clambers
clammer134211793clammer_
clammers143510693clammers
clamper134012993clamper_
clampers143211893clampers
clanger104113493clanger_
clangers114312343clangers
clapper134011863clapper_
clappers143310833clappers
claquer18287353claquer_
claquers19226203claquers
clary105719613cla___ry
clasher124615513clasher_
clashers134213993clashers
clasper113811863clasper_
claspers124410913claspers
classer93614613classer_
classers104111833classers
clatterers12155423clatterers
clattering13109233clattering
clavately1742613clavately
claver113816973cla_ver_
clavers124314903cla_vers
clavier1239173clavier_
claviers1367103claviers
clawer114512783cla_wer_
clawers123910973cla_wers
clayey14407663cla_ye_y
clayier1248323clayier_
clotted104011823clotte_d
clotty11208263clott__y
clouter93511693clouter_
clouters10399803clouters
clovery15407403cl_overy
clownery1633313clownery
cluster94013333cluster_
clusters102912403clusters
cluttered12185943cluttered
clyster12317453clyster_
clysters13227843clysters
coaster94219043coaster_
coasters104317333coasters
coater84329573coa_ter_
coaters93525793coa_ters
coattend1134653coattend
coattest1038863coattest
cotter84926673c_otter_
cotters94323443c_otters
crafter124111333crafter_
crafters13419953crafters
crater85026643cra_ter_
craters95021893cra_ters
critter94113033critter_
critters103511323critters
cutlery12448393c_utlery
cutter84521003c_utter_
cutters94218963c_utters
eatery95316353_ea_tery
elater64724203ela_ter_
elaters74420193ela_ters
fatter94523213_fatter_
feathery17368073feathery
flackery20295243flackery
flatted114012943flatte_d
flatten10429653flatte_n
flattens11357483flattens
flattered13188633flattered
flatterer12187683flatterer
flattest1138713flattest
flitter103413903flitter_
flitters114312173flitters
flutter104012093flutter_
flutters114010823flutters
glaziery21413693glaziery
glitter84211803glitter_
glitters93710543glitters
guttery11427763_guttery
hatter94724873_hatter_
hatters104221523_hatters
heathery17349083heathery
jittery17346443_jittery
lactary1237853_lactary
lantern7310013_lantern
laster64830633_laster_
lasters75627693_lasters
lately93413843_la_tely
later54843923_la_ter_
lather95124363_lather_
lathers104321883_lathers
latte55426303_latte__
latten65018203_latte_n
lattens75014673_lattens
lattes65324203_latte_s
leathery14438973leathery
letter63722583_letter_
letters73819853_letters
litter64324853_litter_
litters73422573_litters
lotter64025603_lotter_
lotters73921063_lotters
mastery124214323_mastery
matter84325343_matter_
matters94421753_matters
natter64420743_natter_
natters73718063_natters
patter84628263_patter_
pattern93712053_pattern
patters94825193_patters
phatter123810203phatter_
plaiter93615393plaiter_
plaiters103512633plaiters
planter94017803planter_
planters102915323planters
plaster93318693plaster_
plasters103518133plasters
plater84427693pla_ter_
platers93924093pla_ters
platier93716293platier_
platted103614263platte_d
plotter94113663plotter_
plotters104011553plotters
pottery123011073_pottery
psaltery13224733psaltery
ratter64326313_ratter_
ratters74422473_ratters
scatter93815173scatter_
scatters103612753scatters
shatter103615703shatter_
shatters113313913shatters
skittery15315103skittery
slabbery15375773slabbery
slater64429183sla_ter_
slaters73123733sla_ters
slatey95417063sla_te_y
slather103816083slather_
slathers113914783slathers
slatier74016813slatier_
slatted84015183slatte_d
slatternly1342233slatternly
slatterns935363slatterns
slavery13407893sla_very
slithery14356703slithery
slitter73615873slitter_
slitters84014133slitters
slotter73314453slotter_
slotters84012403slotters
smatter93613333smatter_
smatters104011713smatters
spatter94016523spatter_
spatters103914703spatters
splatter10348883splatter_
splatters11327543splatters
spluttery14293623spluttery
sputtery13366473sputtery
swatter104113323swatter_
swatters113911793swatters
tatter64024573_tatter_
tatters74520483_tatters
tottery10388483_tottery
twittery14303893twittery
wastery134610993_wastery
watery123914493_wa_tery
watter93221983_watter_
yatter94116213_yatter_
yatters103914623_yatters

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.403443402.0
2DLD Change Limit1461622566.58022213.1
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.07625253.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.