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

272 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
held8533040(None) 
eld46733791_eld
geld65828431geld
head87137171head
heed86437601heed
hell75637891hell
helm95530021helm
helo75332851helo
help95328921help
herd84933061herd
hold86235061hold
meld75830471meld
veld85323201veld
weld84727731weld
yeld811423871yeld
ahead96817052ahead
ahed89536252ahe_d
ahold94714252ahold
auld54125362auld
bald76432902bald
bead75937922bead
bed67950622be_d
beheld1236412beheld
bel57148462bel_
bell66237182bell
bels66142492bels
belt65754032belt
bend76435262bend
bield84614652bield
bled75729312bled
bold75432812bold
cel56040552cel_
cell65031722cell
cels65534972cels
celt65646712celt
chela103916802chela
chield124610212chield
child114516222child
cold77338772cold
dead65434242dead
deed65340902deed
del46752752del_
dele56843082dele
deled75326542deled
delf85436572delf
deli55631292deli
dell56938202dell
dels56745472dels
delt57855272delt
ed38645182_e_d
eel37946842eel_
eels46536742eels
eely77725212eely
el26745292_el_
elds56324852_elds
elf66138522_elf
elk76726122_elk
ell36735682_ell
elm57531742_elm
els37645722_els
end46834352_end
fed76548352fe_d
feed84538902feed
felid94717172felid
fell76833072fell
felt75146932felt
fend84832972fend
feod815523002feod
feud86523022feud
field95015322field
fjeld16465582fjeld
fled85429772fled
fold86528942fold
ged57044532ge_d
geed65435502geed
gel45642432gel_
gelds75118342gelds
gelid74916972gelid
gels56836102gels
gelt56448012gelt
gild65526512gild
gled65631142gled
gold65430162gold
had77658762h_ad
haed86338582haed
hale76052832hale
haled95335822haled
half106238452half
halid94424972halid
hall75741162hall
halm95834972halm
halo76437322halo
halt76056302halt
hand86833702hand
hard85443502hard
he58151952he__
heads95127112heads
heady125117262heady
heal75645692heal
healed105121442healed
heals85733452heals
heap96432892heap
hear76143882hear
heard95222752heard
heat77061422heat
hebe96424702hebe
heck135826492heck
heeds95420422heeds
heel75034222heel
heeled104018412heeled
heels85625532heels
heft106736292heft
heh96039622he_h
hehs106723962hehs
heil76328932heil
heiled104415612heiled
heils85222192heils
heir77523802heir
helio85321192helio
helix154413012helix
helled104024702helled
hello86522982hello
hells85032042hells
helmed124513692helmed
helms105619462helms
helos84928062helos
helot85332682helot
helped124714152helped
helps105219342helps
helve115018092helve
helved134313702helved
hem86148732he_m
heme95034412heme
hemp115725622hemp
hems95534942hems
hen67555272he_n
hens75642572hens
hent76656382hent
hep86644142he_p
her66547812he_r
herald10311342herald
herb94730962herb
herds96424682herds
here76447102here
herl75834552herl
herls85226432herls
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hes66654202he_s
hest75950772hest
het67674312he_t
heth107028022heth
hets75547202hets
hew97642722he_w
hewed125619432hewed
hewn106719852hewn
hews105631572hews
hex137436172he_x
hexad164910622hexad
hexed165615762hexed
hey96741062he_y
hid76248362h_id
hied85434042hied
hila76228352hila
hili75626632hili
hill76439492hill
hilt75850712hilt
hind85529752hind
hod76852462h_od
hoed87837982hoed
holds94623242holds
hole77553392hole
holed95634132holed
holk116027942holk
holm95628102holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
hood85132332hood
hued86925852hued
hula74923752hula
hulk115321612hulk
hull75428782hull
hyla106716512hyla
jeed125428502jeed
jell117125872jell
kelp105322802kelp
kelt85343192kelt
lead56038852lead
led46254552le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146742me_d
meed74934702meed
mel56047482mel_
melds84822382melds
mell64935612mell
mels65941532mels
melt65752892melt
mend75334022mend
mild75330852mild
mold76034332mold
need54934152need
nerd56624942nerd
ohed87825182ohe_d
old47033462_old
ped66751522pe_d
peed76239182peed
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pend75934532pend
pled75231432pled
read55942532read
red46755802re_d
redd66323172redd
reed55549622reed
rely75428952rely
rend56136572rend
seed55549482seed
sel38253322sel_
self75138292self
sell45840612sell
sels46345982sels
send55237292send
shed86536152she_d
shelf115221112shelf
shell84424122shell
shend94719972shend
sherd96321152sherd
shield106212972shield
sild55030582sild
sled55334372sled
sold54837412sold
ted46446562te_d
teed55439262teed
tel35647902tel_
tela45532972tela
tele45040872tele
tell44934702tell
tels46841692tels
tend56433772tend
told56132202told
upheld12115562upheld
vela75725542vela
velds95615582velds
veldt94819862veldt
vend86626422vend
weald95615022weald
wed75843622we_d
weed85637512weed
welds94719162welds
well75832042well
welt75547862welt
wend85330452wend
whelk154311062whelk
whelm134611982whelm
whelp136012092whelp
wield95213912wield
wild85126512wild
wold85429072wold
yald86920602yald
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yield9519692yield
zed135431172ze_d

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit298722720.73340753.1
3Display Results2722720.0634317.5
 (SQL Overall)1786912720.876203985.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.