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

148 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
parlayed143582(None) 
parleyed1436241parleyed
allayed11138062_allayed
arrayed11117152_arrayed
palaced124110772pa_laced
paraded114014262par_aded
paralysed1545742paralysed
paralyzed2445292paralyzed
parbaked1735502parbaked
parlay113713992parlay__
parlays123910452parlay_s
parled94626292parl__ed
parleyer1335632parleyer
parsleyed1543352parsleyed
played124815032p__layed
prayed124815432p_r_ayed
ablated102513443_ablated
alated75625143_a_lated
allayer10148213_allayer
alloyed11158033_alloyed
arcaded1178973_arcaded
arrased8149863_arrased
arrayer10136703_arrayer
assayed1135593_assayed
barraged1297683barraged
belayed133610083_belayed
brayed124615783_br_ayed
carboyed1637183carboyed
clayed125013043__clayed
delayed123310763_delayed
drayed115911393_dr_ayed
flayed134414053__flayed
forayed14368593for_ayed
frayed135012163_fr_ayed
garaged1039253gar_aged
garland948703garla_nd
garlanded1244693garlanded
grayed115415643_gr_ayed
hurrayed1543043hurrayed
lariated91212063lariated
layed95127383___layed
marled95523163marl__ed
narrated9310323narrated
packaged18115753packaged
palace104516913pa_lace_
palaces114216453pa_laces
palate84226783pa_late_
palates93624933pa_lates
palaver1238753pa_laver
paled85538723pa_l__ed
palled94625163pa_l_led
palleted1139873palleted
palliated1238493palliated
palmated132511003palmated
palmed114314643pa_l_med
palpated13249763palpated
palped114513643pa_l_ped
palsied102911303pa_lsied
pancaked1734893pancaked
parade94720643par_ade_
parader103914863par_ader
parades104121463par_ades
parae76335703par_a_e_
parallel1047473parallel
paralyse1347483paralyse
paralyses1448283paralyses
paralyze2246623paralyze
paralyzer2344483paralyzer
paralyzes2346493paralyzes
parapet11317643par_apet
parbake1538353parbake_
parbakes1638343parbakes
parceled1338343parceled
parched154013693par_ched
pardoned12189333pardoned
pared86946763par___ed
parented11912213parented
parged104922043par__ged
pargeted1238683pargeted
parkade1437583parkade_
parkades1538273parkades
parked134425143par__ked
parkland1545373parkla_nd
parlance1248723parlance
parlances1348953parlances
parlando1145413parlando
parlante1039693parlante
parlaying1537303parlaying
parle75836163parl__e_
parles86334403parl__es
parley116718363parl__ey
parleyers1444703parleyers
parleys125212373parley_s
parodied1238333parodied
paroled104217633par_oled
parred95024073par__red
parried103615723par_ried
parroted1158843parroted
parsed96323893par__sed
parslied1137823parslied
partake1339643partake_
partaken1445553partaken
partaker1436873partaker
partakes1449923partakes
parted94228683par__ted
partied103516553par_tied
partyer12337873par_tyer
passaged1236243passaged
patriated1238533patriated
payed115925933p___ayed
pearled10411553pearl__ed
pearlized2145563pearlized
pervaded1535373pervaded
phrased1387383phr_ased
phreaked1834493phreaked
pillaged12298093pillaged
pillared11228093pillared
pirated102515613pir_ated
placed114318003p__laced
planed94420913p__laned
plated95225773p__lated
player115215213p__layer
ployed124310563p__loyed
portaged12228463portaged
portaled11239203portaled
portrayed1564103portrayed
prated94924923p_r_ated
prayer114815293p_r_ayer
preaged11612333p_reaged
preyed125313203p_r_eyed
purled94520753purl__ed
purveyed1743363purveyed
rayed95127503__r_ayed
relayed113212753_relayed
replayed14248633replayed
sashayed1543553sashayed
slayed104716223__slayed
splayed13357813_splayed
sprayed13398903spr_ayed
strayed114513283str_ayed
tallaged10257923tallaged
unallayed1344073unallayed
unarrayed1344183unarrayed
unplayed1437263unplayed
valleyed1534013valleyed
variated121211393variated
walleyed1534153walleyed
waylayer1743153waylayer

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.406440125.6
2DLD Change Limit1461621486.92021121.7
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.38924183.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.