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

328 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
colts7663329(None) 
bolts76232111bolts
celts75325781celts
clots75627641clots
coats75635001coats
colas75436771colas
colds85726971colds
coles76055061coles
cols66553081col_s
colt67158241colt_
coots75636841coots
costs77231141costs
cots68054841co_ts
cults75022551cults
dolts65626311dolts
holts85627911holts
jolts125018881jolts
molts76032091molts
volts85421291volts
alts46639902_alts
belts75931162belts
blots75626172blots
boats75635152boats
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
cants77036942cants
carts78946292carts
casts77237792casts
cats66356342c_ats
cells75428062cells
cels65534972cel_s
celt65646712celt_
cents74730332cents
chats105730092chats
chits105424572chits
cholas114818002cholas
cholos114716852cholos
chotts113610992chotts
cists76624532cists
clods85320862clods
clogs85519552clogs
clons75228132clons
cloots85113692cloots
clops95924852clops
clot66542422clot_
cloth105817542cloth
cloths115512482cloths
clouts87017202clouts
cloys104916942cloys
coacts105314332coacts
coalas87418962coalas
coals76129602coals
coapts104614012coapts
coast75236272coast
coasts85719142coasts
coat67558352coat_
coati75624642coati
coatis85122602coatis
cobalts1139202cobalts
cobbs115013992cobbs
cobles104622882cobles
cobs87043142co_bs
cocas95926572cocas
cocks135227162cocks
cocos95624692cocos
codas84724242codas
codes86247292codes
cods76848102co_ds
coeds85920162coeds
coffs134916302coffs
coft97939682coft_
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
coitus8511892coitus
cokes115537192cokes
col59360352col__
cola66541392col_a
colby124415062colby
colbys13407152colbys
cold77338772col_d
cole66956112col_e
coled85540762coled
coleus86818272coleus
colic95726172colic
colics104219902colics
colies84837052colies
colin76231692colin
colins85229042colins
colitis92617352colitis
collets93517902collets
colly104926772colly
colog86619932colog
cologs96517352cologs
colon78630192colon
colons86028682colons
color76123742color
colors86622372colors
colter84625092colter
colters93522442colters
coltish121310932coltish
coly96940532col_y
colza165112982colza
colzas174010512colzas
comas95833002comas
combs116122962combs
comes97246992comes
comets105823582comets
comps115526052comps
compts125216652compts
comte96125472comte
comtes106222812comtes
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692co_ns
conte76633202conte
contes84432912contes
conto76027172conto
contos84923232contos
conus76726532conus
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coolth1139512coolth
coolths1236012coolths
coons76737282coons
coops96229642coops
coopts105814582coopts
coos67456492co_os
coot67860382coot_
copes97747102copes
coplots11511592coplots
cops86751372co_ps
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
cos510270392co__s
coses76949492coses
cosets85824402cosets
coss66143492co_ss
cost68057942cost_
costa75523732costa
cot510483222co_t_
cote66648732co_te
cotes76347842cotes
cotta75818572cotta
cottas84615572cottas
coulis84018762coulis
counts84618272counts
coups95522472coups
courts84216172courts
couth106122492couth
couths115715412couths
coves105539172coves
covets114819642covets
cowls106922212cowls
cows97046642co_ws
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
crits75527572crits
crofts114910592crofts
culets85518512culets
culls75425812culls
culms95314192culms
cult66541152cult_
culti76317252culti
cultus85110732cultus
cunts76125122cunts
cuts65841152c_uts
cysts105912772cysts
delts65731792delts
doats65224882doats
doits66223672doits
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolt56649422dolt_
dots55647662do_ts
felts85324542felts
folds95221692folds
folks126017122folks
fonts86124752fonts
foots85528282foots
forts86034452forts
gelts65924612gelts
gilts64924262gilts
goats65527302goats
golds75421312golds
golfs95616102golfs
gouts64826172gouts
halts85230102halts
hilts86924412hilts
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holt77852582holt_
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
jilts124717412jilts
joles125230832joles
jolt116639122jolt_
jolty155713032jolty
jots116336142jo_ts
kelts95222632kelts
kilts95122182kilts
kolas94822232kolas
kolos94921212kolos
lilts55822802lilts
lofts85518362lofts
lolls512121732lolls
loots55431422loots
lots47652092lo_ts
louts56330272louts
malts76331752malts
melts74930102melts
milts75430712milts
moats75827642moats
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molt66356162molt_
molto75619602molto
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
moults84713702moults
nolos54423352nolos
nowts86915862nowts
oats46554212_oats
olds55926572_olds
oles46453472_oles
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pelts76128812pelts
plots75025672plots
poets76024442poets
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
ports75934592ports
posts75228782posts
pots66452362po_ts
poults84613482poults
pouts75530322pouts
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roots55933672roots
rotls55620162rotls
rots46454092ro_ts
routs57133412routs
salts55431882salts
scolds95011232scolds
scoots85315942scoots
scots74025912sco_ts
scouts84817942scouts
silts55330822silts
slots54830532slots
smolts84411882smolts
softs85019232softs
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
soots55536212soots
sorts54536662sorts
sots45552452so_ts
tilts55325612tilts
tofts84919242tofts
toits55327472toits
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
voles86234042voles
volt76439532volt_
volta85215622volta
volte85321302volte
voltes94915582voltes
volti84915962volti
welts85225192welts
wilts85023502wilts
wolds95420182wolds
wolfs116214162wolfs
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
yolks125412772yolks

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 Limit538003281.42337807.4
3Display Results3283280.0933526.9
 (SQL Overall)1786913281.82997698.7
 
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.