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

260 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
dolts6562631(None) 
bolts76232111bolts
colts76633291colts
delts65731791delts
doats65224881doats
doits66223671doits
doles67843751doles
dolls66126921dolls
dols56943051dol_s
dolt56649421dolt_
dots55647661do_ts
holts85627911holts
jolts125018881jolts
molts76032091molts
volts85421291volts
adopts998082adopts
adults7299952adults
alts46639902_alts
belts75931162belts
blots75626172blots
boats75635152boats
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
celts75325782celts
clots75627642clots
coats75635002coats
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082col_s
colt67158242colt_
coots75636842coots
costs77231142costs
cots68054842co_ts
cults75022552cults
dales66439742dales
dals57145122dal_s
darts67635732darts
dauts67822242dauts
dawts97216122dawts
debts86418372debts
deets65330242deets
deles65139252deles
delfs94918672delfs
delfts10439672delfts
delis64928542delis
dells66630942dells
dels56745472del_s
delt57855272delt_
delta66117772delta
deltas74414822deltas
dents65031802dents
dholes104914792dholes
diets66026642diets
dills65530972dills
dints67431312dints
diols65521012diol_s
dirts66824462dirts
dits56450522d_its
doat56947672doat_
doblas93812292doblas
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doest65829522doest
doeth9411982doeth
doffs125614332doffs
doges75630162doges
dogs66440152do_gs
doit56347852doit_
dojos135111792dojos
dol47150652dol__
dolce85816682dolce
dolci84912602dolci
dole56550002dol_e
doled75430912doled
doll56632492dol_l
dolly96125202dolly
dolma86214172dolma
dolmas95213042dolmas
dolor67617962dolor
dolors75115312dolors
doltish11118732doltish
domes85735562domes
doms76239572do_ms
donas65926472donas
dongs76525812dongs
dons56048702do_ns
donuts7410582donuts
dooms85321342dooms
doors65022132doors
dopas85019062dopas
dopes84935042dopes
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dorty96220812dorty
dos48062312do__s
doses65938502doses
doss56235042do_ss
dost57248352dost_
dot47573182do_t_
dote55442882do_te
dotes65836692dotes
doth86225712do_th
dotty94516102dotty
doty86128222do_ty
doubts968732doubts
doulas75114992doulas
doums85417642doums
doves94728152doves
downs94918572downs
dows85941052do_ws
dozes155226302dozes
drats66628372drats
droits74314312droits
drolls75312392drolls
ducts85319892ducts
duets65323882duets
duits65021882duits
dulls64523742dulls
dunts65828412dunts
dusts65923562dusts
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
idols65514132idol_s
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
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 3 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.376475242.0
2DLD Change Limit538002601.87328724.0
3Display Results2602600.0634127.0
 (SQL Overall)1786912602.31277288.5
 
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.