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

203 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
updried1122647(None) 
undried92314611undried
updries10209081updries
dried75321382__dried
pried84426862_p_ried
redried93714892redried
untried82615852untried
updarted1244312updarted
updated11369422updated
updived1434092updived
aeried74221863_aeried
aperies9423203aperies
applied1247483applied
apprised1337713apprised
apprized2236543apprized
bedrid1039943bedri_d
berried103714043berried
birdied11329433birdied
bodied103814583bod_ied
buddied12388003buddied
buried94822373_buried
caddied123710563caddied
caried94528693_caried
carried103717153carried
cried84624283__cried
curried103313653curried
decried112612853decried
died66137853__d_ied
dreed75222843__dreed
drier64423963__drier
dries64733673__dries
duperies11312813duperies
eddied9248323_eddied
epoxied1734813epoxied
ferried113411523ferried
fried95322913__fried
giddied11257713giddied
gloried9169523gloried
harried113815533harried
herried113514453herried
hundred1237143hundr_ed
hurried113511043hurried
hydrid14248973hydri_d
hydride15257503hydride
juried144212443_juried
married104715303married
muddied12339213muddied
outcried1139543outcried
paired95017523_paired
pared86946763_par_ed
parged104922043_parged
paries84742513_paries
parked134425143_parked
parled94626293_parled
parred95024073_parred
parried103615723parried
parsed96323893_parsed
parted94228683_parted
partied103516553_partied
periled10316323_periled
period9314983_period
perked134617693_perked
permed115217353_permed
pied75035363_p__ied
pitied94017253_pitied
plied85118593_p_lied
ponied94920703_ponied
pored85234513_por_ed
porked134717623_porked
ported94223243_ported
predried12309573predried
preed85128123_p_reed
priced115018883_p_riced
pride84724733_p_ride
prided103618033_p_rided
prier75027763_p_rier
pries74339533_p_ries
primed115118913_p_rimed
prised94322203_p_rised
prized184415393_p_rized
puddled123011193puddled
pudgier11377723pudgier
pureed95017813_pureed
purged104918263_purged
purled94520753_purled
purred94218073_purred
pursed95220883_pursed
putrid9311173putri_d
puttied103811163puttied
quarried1836093quarried
queried1738683queried
redries83721713redries
refried113513873refried
retried84419153retried
scried95817303_scried
serried82513963serried
spared95427493spar_ed
sparged113512763sparged
sparid94016933spari_d
sparked143513143sparked
sparred104512863sparred
speired103811103speired
spied85427713sp__ied
spired94921863spir_ed
spirier93214073spirier
spirited1148973spirited
spirted103913073spirted
spored94821793spor_ed
sported104015433sported
sprier84119063sp_rier
spurned10339263spurned
spurred103610623spurred
spurted103111973spurted
storied8515163storied
sundries9312023sundries
supered10316123super_ed
supplied1345993supplied
tarried83914133tarried
tidied83613273tid_ied
tried65026913__tried
umpired1235783umpir_ed
unaired82916013unaired
unarmed101811923unarmed
unbred92613303unbr_ed
unburied11208513unburied
undated93118463undated
undenied102211563undenied
underfed13311713underfed
underived14310513underived
undid72415363und_i_d
undies73821963und_ies
undrained1138523undrained
undraped1239393undraped
undrew1037913undr_ew
undrilled1146663undrilled
undyed1138143und_yed
unfired112212453unfired
unfreed11510123unfreed
unhired112512153unhired
unified112413573unified
unpaired11208943unpaired
unparted11310823unparted
unpitied1138793unpitied
unpriced1338143unpriced
unprimed1337203unprimed
unprized2038513unprized
unpurged1236293unpurged
unrimed102211633u_nrimed
untied73720813u_ntied
untired82316383untired
unurged939143unurged
unvaried1239683unvaried
upbind11246313up_bind
upboiled13194853upboiled
upbraid1244973upbraid
upbraided1542963upbraided
upbuild1243003upbuild
upcoiled13215183upcoiled
upcurled1393783upcurled
upcurved16142993upcurved
update93810293update_
updater10347253updater
updates10329793updates
updive1234903upd_ive
updives1334713updives
updove1234483updove_
updraft1346033updraft
updry1135483updr__y
updrying1534013updrying
upended11267323upended
upfield1343033up_field
upgazed2033423upgazed
upgird10103933up_gird
upgirded1342333upgirded
upgrade11215823upgrade
upgraded13215683upgraded
upgrew1233653upgr_ew
uphroe1136083uphroe_
uphroes1236303uphroes
upped103715163up__ped
uppiled12216593uppiled
upraised11167413upraised
uprated103213323uprated
uprise82313693up_rise
uprisen9227353up_risen
upriser9218763up_riser
uprises92012733up_rises
upriver12196933up_river
upside9289803up_side
upsized19246253upsized
upsurged12124043upsurged
uptrend1044293uptrend
upturned11214013upturned
upwind12255823up_wind
urged75316033u__rged
urped84615283u__rped
usuries7510633usuries
usurped1035153usurped
varied104817863_varied
waddied13358563waddied
wearied112911803wearied
worried11308693worried
wried95518563__wried

Search took 8 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 Limit1340272037.12618808.2
3Display Results2032030.0633222.2
 (SQL Overall)1786912037.59523527.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.