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 “meld” 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
meld7583047(None) 
eld46733791_eld
geld65828431geld
held85330401held
mead75531601mead
med66146741me_d
meed74934701meed
mel56047481mel_
melds84822381melds
mell64935611mell
mels65941531mels
melt65752891melt
mend75334021mend
mild75330841mild
mold76034331mold
veld85323201veld
weld84727731weld
yeld811423871yeld
amend85717752amend
auld54125362auld
bald76432902bald
bead75937922bead
bed67950622be_d
bel57148462bel_
bell66237182bell
bels66142492bels
belt65754032belt
bend76435262bend
bield84614652bield
bled75729312bled
bold75432812bold
cel56040552cel_
cell65031722cell
cels65534972cels
celt65646712celt
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
emend86214892emend
emyd1047072emyd
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
head87137172head
heed86437602heed
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
herd84933062herd
hold86235062hold
jeed125428502jeed
jell117125872jell
kelp105322802kelp
kelt85343192kelt
lead56038852lead
led46254552le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mad68958702m_ad
maid75537632maid
male66052292male
mall64639362mall
malm85129972malm
malt66254802malt
maud75325392maud
me47748332me__
meads85425322meads
meal65643172meal
meals75933372meals
mealy104422182mealy
mean65538082mean
meat66359602meat
meds75735362meds
meeds84920272meeds
meek105624832meek
meet65350552meet
meg66040952me_g
mega77620872mega
megs75530632megs
melded104714712melded
melder93915812melder
melee73729102melee
melic94722332melic
melled95023022melled
mells75031332mells
melody1237202melody
meloid9615992meloid
melon73922082melon
melted94219062melted
melts74930102melts
melty104918362melty
mem77943472me_m
meme85330552meme
memo85924792memo
mems85931502mems
men59252842me_n
menad85918982menad
mends84927692mends
meno66031352meno
menu65130222menu
meou65325862meou
meow95117882meow
merc87225622merc
merde84320122merde
mere67244442mere
merk106027942merk
merl65830972merl
merle75824372merle
merls77423902merls
mesa67025482mesa
mesh96823002mesh
mess65932432mess
met56072432me_t
meta65932412meta
mete64438132mete
meted85424432meted
meth95827842meth
mew86137732me_w
mewed115218012mewed
mewl95618322mewl
mewled123710052mewled
mewls105813232mewls
mews96629332mews
meze154420902meze
mid67354452m_id
mil55752102mil_
milds86422052milds
mile66352562mile
milk105028462milk
mill66541472mill
milo65536092milo
mils66045322mils
milt65455802milt
mind75434362mind
mod69054402m_od
mol56654592mol_
mola66035632mola
molds85324832molds
moldy115014652moldy
mole66251832mole
moll66735702moll
mols65948572mols
molt66356162molt
moly96031912moly
mood76332062mood
mould86015752mould
mud67336862m_ud
mule65236972mule
muled85824432muled
mull65128802mull
need54934152need
nerd56624942nerd
old47033462_old
ped66751522pe_d
peed76239182peed
pele65539552pele
pelf97031452pelf
pelt67651082pelt
pend75934532pend
pled75231432pled
read55942532read
red46755802re_d
redd66323172redd
reed55549622reed
rely75428952rely
rend56136572rend
seed55549482seed
sel38253322sel_
self75138292self
sell45840612sell
sels46345982sels
send55237292send
sild55030582sild
sled55334372sled
smell74916232smell
smelt74726782smelt
sold54837412sold
ted46446562te_d
teed55439262teed
tel35647902tel_
tela45532972tela
tele45040872tele
tell44934702tell
tels46841692tels
tend56433772tend
told56132202told
vela75725542vela
velds95615582velds
veldt94819862veldt
vend86626422vend
weald95615022weald
wed75843622we_d
weed85637512weed
welds94719162welds
well75832042well
welt75547862welt
wend85330452wend
wield95213912wield
wild85126512wild
wold85429072wold
yald86920602yald
yelk115320002yelk
yell76028322yell
yelp95621352yelp
yield9519692yield
zed135431172ze_d

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 Filter178691298720.0802233637.5
2DLD Change Limit298722470.92032469.6
3Display Results2472470.0465369.6
 (SQL Overall)1786912471.046170832.7
 
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.