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 “jerreed” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

223 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
jerreed153521(None) 
jereed144012071je_reed
jerreeds1653271jerreeds
berried103714052berried
decreed112710262decreed
degreed10258882degreed
erred65915672_err_ed
ferreled1234842ferreled
ferreted1236332ferreted
ferried113411532ferried
herried113514472herried
jarred144613252jarr_ed
jeered143912792jeer_ed
jereeds15326392je_reeds
jerked18479592je_rked
jerrid14259142jerr_id
jerries143817512jerries
jerseyed1942742jerseyed
rebreed104611072rebreed
serried82513972serried
terreen7257572terreen
aerated85322383aerated
aeried74221873ae_ried
agreed84712503_agreed
averred11237593averr_ed
barred95725803barr_ed
barreled1137853barreled
bearded114212133bearded
beraked144312433beraked
berated104422133berated
berimed124912283berimed
bermed115217723be_rmed
berobed1238243berobed
berries94423553berries
berseem1166463berseem
berthed13259123berthed
birred94713203birr_ed
breed85526693__breed
burred95820723burr_ed
burseed1049503burseed
burweed1347823burweed
carried103717153carried
cerated103922473cerated
cered85227443ce_r_ed
creed85727393__creed
curred94319263curr_ed
curried103313653curried
decree93117783decree_
decreer10269123decreer
decrees102513123decrees
decried112612863decried
deerweed1344193deerweed
degree82814853degree_
degrees92810723degrees
derated93623503derated
derided102914253derided
derived123912763derived
derries83124623derries
dreed75222843__dreed
eared65139503_ear_ed
earned74818333_earned
emceed1136283_emceed
erased74816763_erased
eroded84313593_eroded
errand758793_errand
exceed1636173_exceed
feared106320433fear_ed
ferrel92810203ferr_el
ferrelled1343943ferrelled
ferrels10248623ferrels
ferret93021173ferr_et
ferreter1136543ferreter
ferrets103111393ferrets
ferrety13287013ferrety
ferries103521083ferries
ferruled1263923ferruled
feruled11318423feruled
fevered14339723fevered
freed95223543__freed
furred104514433furr_ed
garred85217413garr_ed
garreted1057523garreted
geared85317743gear_ed
greed75125693__greed
harried113815543harried
hearsed113811423hearsed
hearted113314033hearted
heired103813043heir_ed
herbed123513453he_rbed
herded114215643he_rded
herries104025083herries
hurried113511043hurried
inbreed10267643inbreed
jarhead1835173jarhead
jeaned143813463je_aned
jeed125428503j___eed
jeeped16469843je_eped
jeerer13389933jeer_er
jeerers14328923jeerers
jelled144916063je_lled
jellied15419223jellied
jemmied19294483jemmied
jerid132316423je_r_id
jerker17369043je_rker
jerkers18287083jerkers
jerkier18407273jerkier
jerkies183411583jerkies
jerrids15277743jerrids
jerry155016183jerr__y
jersey1636333je_rsey
jerseys1733243jerseys
jessed144112303je_ssed
jested144416503je_sted
jetbead1742983jetbead
jetted143915083je_tted
jettied15366973jettied
jewed165114833je__wed
jeweled1845333jeweled
juried144212443j_uried
kerbed13339703ke_rbed
kerfed14358233ke_rfed
kerned114112933ke_rned
kerneled1344033kerneled
kerries113317913kerries
learned8329303learned
leered73816223leer_ed
leveed104111373le_veed
levered114212303levered
marred95421043marr_ed
married104715303married
merged104214953me_rged
mergee94018143mergee_
mergees104411233mergees
merited10313853merited
merrier92612303merrier
metered103514013metered
metred95315143metr_ed
neared75119813near_ed
nereid7312933ne_reid
nerved104111693ne_rved
oersted839563oersted
overbreed1548043overbreed
overfeed15299443overfeed
overseed122513353overseed
parred95024073parr_ed
parried103615723parried
pearled10411553pearled
peered93819493peer_ed
perched154713243perched
periled10316323periled
perked134617693pe_rked
permed115217353pe_rmed
perpend12259353perpend
perries93226603perries
peruked14367893peruked
perused103112203perused
petered103314973petered
preed85128123__preed
pureed95017813_pureed
purred94218073purr_ed
reared75930013rear_ed
rearmed103912823rearmed
rebred95816353rebr_ed
rebreeds11426003rebreeds
redried93714903redried
reed55549623___reed
refeed104717623re_feed
refereed12149693refereed
refried113513883refried
regreen8309043regreen
regreet83015953regreet
reread71715433re_read
reseed74823293re_seed
retread849003retread
retried84419163retried
revered112819333revered
screed95718933_screed
seared75232843sear_ed
seaweed11108813seaweed
secreted1138643secreted
sered65737293se_r_ed
serged84118773se_rged
serifed11811463serifed
serrated92513433serrated
serries73925353serries
served104616813se_rved
severed113513863severed
sewered112911243sewered
sirree64017343sirree_
sirrees73410573sirrees
tarred74720283tarr_ed
tarried83914133tarried
tarweed1137343tarweed
teared75722153tear_ed
termed94816703te_rmed
terraced11318133terraced
terrae62915213terrae_
terreens8246533terreens
terrene72411033terrene
terrenes82212603terrenes
terret63425623terr_et
terrets72913583terrets
terrier73414963terrier
terries73425633terries
treed65626733__treed
turreted935373turreted
unfreed11510123unfreed
veered103612743veer_ed
verged114815163ve_rged
versed104515523ve_rsed
warred104019853warr_ed
wearied112911823wearied
weeweed1435193weeweed
weirded1234513weirded
wergeld1233183wergeld
wherried15175023wherried
worried11308693worried
xeroxed14244533xeroxed
yearend11285703yearend
yearned11327373yearned
yerked14509373ye_rked
yirred10426963yirr_ed
zeroed16409423ze_roed

Search took 9 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272238.15616432.9
3Display Results2232230.0762934.2
 (SQL Overall)1786912238.63820686.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.