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 “clots” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

247 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
clots7562764(None) 
blots75626171blots
clods85320861clods
clogs85519551clogs
clons75228131clons
cloots85113691cloots
clops95924851clops
clot66542421clot_
cloth105817541cloth
cloths115512481cloths
clouts87017201clouts
cloys104916941cloys
colts76633291colts
coots75636841coots
cots68054841c_ots
lots47652091_lots
plots75025671plots
slots54830531slots
allots64019172allots
aloes54933672aloes
altos55822952altos
alts46639902al_ts
blats75132502blats
blets75324942blets
bloats85215762bloats
blobs95620032blobs
blocs95219652blocs
blogs85319232blogs
blot65842322blot_
blows105423832blows
bolts76232112bolts
boots75837972boots
bots66453952_bots
calos74431902calo_s
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342c_ats
celoms10412122celoms
celts75325782celts
cents74730332cents
chats105730092chats
chits105424572chits
chops125019872chops
chott103923932chott
chotts113610992chotts
chows135618202chows
cions75222852cions
cists76624532cists
clads85722732clads
clags85621122clags
clams95127672clams
clans75031012clans
claps95626182claps
class75525482class
clast76030582clast
clasts84817292clasts
claws106020832claws
clays105521332clays
cleats84919312cleats
clefs106616242clefs
clefts114610162clefts
clews105516332clews
clifts11519152clifts
clips96018302clips
cloak115214012cloak
cloaks124411262cloaks
clock134917982clock
clocks144916232clocks
clod76124612clo_d
clog76123242clo_g
clomb115714702clomb
clomp115615702clomp
clomps125212232clomps
clon66232482clo_n
clone75728162clone
clones84526562clones
clonk114417442clonk
clonks125013472clonks
clonus85212412clonus
cloot76127052cloot
clop86929892clo_p
close76425222close
closes85425592closes
closets94611602closets
clothe114712992clothe
clothes124513812clothes
clotty11208262clotty
cloud86716422cloud
clouds94612352clouds
clour76617282clour
clours85215092clours
clout75330462clout
clove105619442clove
cloves114918822cloves
clown105214732clown
clowns114810112clowns
cloy96623832clo_y
cloze165517542cloze
clozes174915562clozes
clubs95415102clubs
clues74623032clues
coats75635002coats
cobs87043142c_obs
cods76848102c_ods
cogs77340032c_ogs
colas75436772colas
colds85726972colds
coles76055062coles
cologs96517352cologs
colons86028682colons
colors86622372colors
cols66553082c_ols
colt67158242colt_
cons66057692c_ons
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coopts105814582coopts
coos67456492c_oos
coot67860382coot_
coplots11511592coplots
cops86751372c_ops
cors66656442c_ors
cos510270392c_o_s
coss66143492c_oss
cost68057942c_ost
costs77231142costs
cot510483222c_ot_
cote66648732c_ote
cotes76347842c_otes
cows97046642c_ows
coys97537242c_oys
crits75527572crits
crocs95722432crocs
crofts114910592crofts
crops96125232crops
cross75124502cross
crows105727312crows
culets85518512culets
cults75022552cults
cunts76125122cunts
cuts65841152c_uts
cysts105912772cysts
dolts65626312dolts
dots55647662_dots
eclats8313032eclats
flats86429742flats
flits85625222flits
floats96816252floats
flocs105519232flocs
floes85528142floes
flogs95919962flogs
flops105920142flops
floss85118262floss
flota85315642flota
flotas94013002flotas
flouts94315272flouts
flows115822362flows
foots85528282foots
gloats74515422gloats
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glost65422932glost
glosts74513812glosts
glouts74414712glouts
glows95518032glows
gluts66120132gluts
grots65025852grots
helots95217702helots
holts85627912holts
hoots84830252hoots
hots78349332_hots
jolts125018882jolts
jots116336142_jots
knots95614722knots
lats45962702_lats
lets47147942_lets
lits46252492_lits
lobs66441082_lobs
lofts85518362_lofts
logs57343112_logs
loos49051122_loos
loots55431422loots
lops66043352_lops
loss45337962_loss
lost47951492_lost
lot38179262_lot_
lota47233502_lota
lotas55926302_lotas
loth76132132_loth
loti46431842_loti
lotos54724632_lotos
lotus55718062_lotus
louts56330272_louts
lows75843012_lows
molts76032092molts
moots75831662moots
mots66853162_mots
ocelots977232ocelots
oots46446442_oots
phots105418502phots
pilots84018872pilots
plats75531372plats
plods85719292plods
plops95920332plops
plot66141232plot_
plotz164617002plotz
plows105419902plows
ploys105816592ploys
pots66452362_pots
riots54922012riots
roots55933672roots
rots46454092_rots
ryots85313782ryots
scoots85315942scoots
scots74025912scots
shots84730852shots
slats55436902slats
slits56128852slits
slobs74419872slobs
sloes54728872sloes
slogs64521842slogs
slops75026012slops
slot46049832slot_
sloth85019452sloth
sloths94911892sloths
slows85323462slows
sluts54523982sluts
snots55225122snots
soots55536212soots
sots45552452_sots
spots74424112spots
stots54828552stots
swots85518432swots
toots55331872toots
tots46654122_tots
trots56629942trots
volts85421292volts
wots76342892_wots
zlote143912942zlote
zloty17399792zloty
zlotys18374172zlotys

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538002471.58034050.6
3Display Results2472470.0604116.7
 (SQL Overall)1786912471.95391495.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.