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

193 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
yeld81142387(None) 
eld46733791_eld
geld65828431geld
held85330401held
meld75830471meld
veld85323201veld
weld84727731weld
yald86920611yald
yelk115320001yelk
yell76028321yell
yelp95621351yelp
yield9519691yield
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
dyed96720762dye_d
ed38645182_e_d
eel37946842eel_
eels46536742eels
eely77725212eely
el26745292_el_
elds56324852_elds
elf66138522_elf
elk76726122_elk
ell36735682_ell
elm57531742_elm
els37645722_els
end46834352_end
eyed86623232eyed
eyelid1038442eyelid
fed76548352fe_d
feed84538902feed
felid94717172felid
fell76833072fell
felt75146932felt
fend84832972fend
feod815523002feod
feud86523022feud
field95015322field
fjeld16465582fjeld
fled85429772fled
fold86528942fold
ged57044532ge_d
geed65435502geed
gel45642432gel_
gelds75118342gelds
gelid74916982gelid
gels56836102gels
gelt56448012gelt
gild65526512gild
gled65631142gled
gold65430162gold
head87137172head
heed86437602heed
hell75637892hell
helm95530022helm
helo75332852helo
help95328922help
herd84933062herd
hold86235062hold
jeed125428502jeed
jell117125872jell
kelp105322802kelp
kelt85343192kelt
lead56038852lead
led46254552le_d
lend56233672lend
leud57223422leud
lewd85716592lewd
mead75531602mead
med66146742me_d
meed74934702meed
mel56047482mel_
melds84822382melds
mell64935612mell
mels65941532mels
melt65752892melt
mend75334032mend
mild75330852mild
mold76034332mold
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
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
wyled124611842wyled
yard85633252yard
yaud87020082yaud
yauld95511182yauld
yclad11246382yclad
ye57650062ye__
yea66445752ye_a
yeah106725412yeah
yean75834582yean
year76534252year
yeas78638422yeas
yech127220532yech
yegg96511792yegg
yeh97135772ye_h
yelks126413622yelks
yelled104116252yelled
yells85821942yells
yelped12439362yelped
yelps105712992yelps
yen66847382ye_n
yens75832262yens
yep86638962ye_p
yeps95924402yeps
yerk116222082yerk
yes66250612ye_s
yet66960692ye_t
yeti75823212yeti
yett76434492yett
yeuk116015472yeuk
yew96436292ye_w
yews105323962yews
yid76640832y_id
yields10466842yields
yill75628972yill
yird87018982yird
ylem9217892ylem
yod77545502y_od
yolk116218992yolk
yond86122312yond
yule75725142yule
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.436409841.7
2DLD Change Limit298721930.96630923.4
3Display Results1931930.0503860.0
 (SQL Overall)1786911931.452123065.4
 
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.