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

130 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
parleyed143624(None) 
parlayed1435821parlayed
parleyer1335631parleyer
parsleyed1543351parsleyed
palleted1139872palleted
parceled1338342parceled
pargeted1238682pargeted
parled94626292parl__ed
parley116718362parley__
parleyers1444702parleyers
parleys125212372parley_s
preyed125313202p_r_eyed
purveyed1743362purveyed
valleyed1534012valleyed
walleyed1534152walleyed
allayed11138063_allayed
alleged9389323_alleged
alloyed11158033_alloyed
arrayed11117153_arrayed
barbered13259543barbered
barley115116763barley__
barleys125011843barley_s
barreled1137853barreled
bartered113113023bartered
blarneyed1542153blarneyed
carboyed1637183carboyed
careened1139193careened
careered1139493careered
carpeted1338953carpeted
darkened1435943darkened
fleyed13408813__fleyed
galleted1038223galleted
gardened1137003gardened
garnered10247113garnered
garreted1057523garreted
gartered10319593gartered
gleyed11478153__gleyed
greyed114610603_gr_eyed
hardened1338613hardened
harkened1637483harkened
hawkeyed2242403hawkeyed
jerseyed1942743jerseyed
lackeyed18104513lackeyed
marketed1537323marketed
marled95523163marl__ed
marveled1436433marveled
packeted17148283packeted
palaced124110783pa_laced
paleae84820293pa_leae_
paled85538723pa_l__ed
palled94625163pa_l_led
palmed114314643pa_l_med
palped114513643pa_l_ped
palsied102911303pa_lsied
paltered113012493paltered
pampered15229233pampered
pandered121812573pandered
paneled10612573pa_neled
panelled1138963panelled
papered122513173pa_pered
paraded114014263par_aded
paralleled1343743paralleled
paralysed1545743paralysed
paralyzed2445293paralyzed
parapeted1446483parapeted
parbaked1735503parbaked
parcelled1445783parcelled
parcener1238473parcener
parched154013693par_ched
pardee93922023parde_e_
pardoned12189333pardoned
pared86946763par___ed
parented11912213parented
pareses94718883par_eses
pareve114613013par_eve_
parged104922043par__ged
pargetted1345663pargetted
parietes10714543parietes
parked134425143par__ked
parlay113713993parlay__
parlays123910453parlay_s
parle75836163parl__e_
parles86334403parl__es
parleying1536113parleying
parodied1238343parodied
paroled104217633par_oled
parolee94119653parole_e_
parolees104313983parole_es
parqueted2144223parqueted
parred95024073par__red
parried103615723par_ried
parroted1158853parroted
parsed96323893par__sed
parsley1247803parsley__
parsleys1335083parsley_s
parslied1137823parslied
parted94228683par__ted
partied103516553par_tied
partnered1244483partnered
partyer12337873par_tyer
pattened11299393pattened
pattered112714203pattered
paupered13216943paupered
paveed12438893pa_ve_ed
payed115925933pa___yed
pearled10411553pearl__ed
pearlized2145563pearlized
pelleted1138203pelleted
perplexed2143263perplexed
phoneyed1743843phoneyed
played124815033p__layed
ployed124310563p__loyed
pollened1157783pollened
popeyed1535713p_opeyed
portered112311543portered
prayed124815433p_r_ayed
preed85128123p_r_e_ed
preened103214993p_reened
premed114617763p_r_emed
preyer114413733p_r_eyer
pureed95017813pur_e_ed
purled94520753purl__ed
surveyed1544233surveyed
tableted1137533tableted
targeted1037483targeted
tarweed1137343tarwe_ed
valeted1139013va_leted
volleyed1543533volleyed
walleye1336243walleye_
walleyes1435603walleyes

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621307.08020644.4
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.54623680.2
 
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.