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

251 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
delts6573179(None) 
belts75931161belts
celts75325781celts
debts86418371debts
deets65330241deets
deles65139251deles
delfs94918671delfs
delfts10439671delfts
delis64928541delis
dells66630941dells
dels56745471del_s
delt57855271delt_
delta66117771delta
deltas74414821deltas
dents65031801dents
dolts65626311dolts
felts85324541felts
gelts65924611gelts
kelts95222631kelts
melts74930101melts
pelts76128811pelts
welts85225191welts
adepts9117102adepts
adults7299952adults
alts46639902_alts
beats76042242beats
beets76131442beets
bells76432162bells
bels66142492bel_s
belt65754032belt_
bents76033692bents
bests75932612bests
bets67051442be_ts
blets75324942blets
bolts76232112bolts
cells75428062cells
cels65534972cel_s
celt65646712celt_
cents74730332cents
colts76633292colts
cults75022552cults
dales66439742dales
dals57145122dal_s
darts67635732darts
dauts67822242dauts
dawts97216122dawts
deads75726912deads
deals65435342deals
dealt65234282dealt_
deans66131392deans
dears65736882dears
death94822522death
deaths105914442deaths
debits94214502debits
debs76530242de_bs
debt77139022debt_
debuts93911752debuts
decks124822192decks
decos85522122decos
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deet57356582deet_
defats105114552defats
defis96717502defis
deft85540222deft_
degas75119162degas
deils65722862deils
deist64633592deist
deists74916432deists
deity94316772deity
dekes105224452dekes
del46752752del__
delate73827752delate
delates83526282delates
delay94820632delay
delays104014052delays
dele56843082del_e
deled75326542deled
delete73620702delete
deletes83117932deletes
delf85436572del_f
delft95623322delft
deli55631292del_i
delicts104012252delicts
delish105215612delish
delist74625052delist
delists84414172delists
dell56938202del_l
delly96023872delly
deltic9312502deltic
delve96018262delve
delves104917082delves
demes86032692demes
demits94918072demits
demos86022992demos
denes65639722denes
dens55945072de_ns
dent57158412dent_
depots94716342depots
depth114311852depth
depths12428572depths
derats74625062derats
derms85022892derms
desalts839572desalts
desks105913072desks
devas96218882devas
devs86424032de_vs
dews86230602de_ws
dexes135224512dexes
deys85027472de_ys
diets66026642diets
dills65530972dills
dints67431312dints
dirts66824462dirts
dits56450522d_its
doats65224882doats
doits66223672doits
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolt56649422dolt_
dots55647662d_ots
drats66628372drats
ducts85319892ducts
duels65619232duel_s
duets65323882duets
duits65021882duits
dulls64523742dulls
dunts65828412dunts
dusts65923562dusts
dwells10417712dwells
dwelt94316522dwelt_
eats47054872_eats
edits65819032edits
eels46536742eel_s
efts76519482_efts
elds56324852_elds
elks85820032_elks
ells46431352_ells
elms67322702_elms
els37645722_el_s
feats86432752feats
fells85327382fells
felt75146932felt_
fests85828042fests
fets75345942fe_ts
gelds75118342gelds
gels56836102gel_s
gelt56448012gelt_
gents65729612gents
gests66028812gests
gets55442482ge_ts
gilts64924262gilts
halts85230102halts
heats85838402heats
hefts116218152hefts
hells85032042hells
helms105619462helms
helos84928062helos
helots95217702helots
helps105219342helps
hents87330742hents
hests85829932hests
hets75547202he_ts
hilts86924412hilts
holts85627912holts
jells125522162jells
jests125922452jests
jets115834102je_ts
jilts124717412jilts
jolts125018882jolts
keets95123482keets
kelps115116422kelps
kelt85343192kelt_
kilts95122182kilts
leets54927122leets
lefts86517812lefts
lets47147942le_ts
lilts55822802lilts
malts76331752malts
meats75034052meats
meets74224612meets
melds84822382melds
mells75031332mells
mels65941532mel_s
melt65752892melt_
melty104918362melty
milts75430712milts
molts76032092molts
neats55931902neats
nerts55924982nerts
nests55728002nests
nets45941532ne_ts
netts55320722netts
newts86015282newts
peats76140192peats
peles75738082peles
pelfs105016292pelfs
pelt67651082pelt_
pests75933272pests
pets66248332pe_ts
relets64025672relets
rents55935182rents
rests54935872rests
rets45352562re_ts
salts55431882salts
seats54844342seats
sects75622892sects
selfs85220242selfs
sells55134432sells
sels46345982sel_s
septs75420602septs
sets45549502se_ts
setts55124322setts
sexts125118382sexts
silts55330822silts
smelts85412772smelts
spelts84614642spelts
teats55636812teats
teles54536002teles
tells55828942tells
telos55424522telos
tels46841692tel_s
tents56434212tents
tests56530192tests
tets45847462te_ts
texts125515042texts
tilts55325612tilts
velds95615582velds
veldts10417752veldts
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092ve_ts
volts85421292volts
weets85427722weets
wefts116715492wefts
welds94719162welds
wells85426192wells
welt75547862welt_
wests85727002wests
wets75940292we_ts
wilts85023502wilts
yelks126413622yelks
yells85821942yells
yelps105712992yelps
yetts86715132yetts
zests145419742zests

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.313570897.8
2DLD Change Limit538002511.65632487.9
3Display Results2512510.0633984.1
 (SQL Overall)1786912512.03287938.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.