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

165 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
parslied113782(None) 
palsied102911302pals_ied
parled94626292par_l_ed
parodied1238332parodied
paroled104217632parol_ed
parried103615722par_ried
parsed96323892pars__ed
parsley1247802parsl_ey
parsleyed1543352parsleyed
partied103516552par_tied
warsled112910442warsl_ed
aisled74516183_aisl_ed
allied74217153_a_llied
applied1247483_applied
argled85314553_argl_ed
ariled75620323_aril_ed
barflies1338303barflies
caried94528693car__ied
caroled103717693carol_ed
carolled1138833carolled
carried103717153car_ried
daisied93410013dais_ied
dallied93713613da_llied
darkled13378723darkl_ed
darklier1335013darklier
dartled9409853dartl_ed
earlier72612743ear_lier
farside1138603fars_ide
gallied94115003ga_llied
garbled114512803garbl_ed
gargled104210673gargl_ed
harried113815533har_ried
harslet10315653harsl_et
hassled11358303hassl_ed
hirsled11118113hirsl_ed
marbled123212113marbl_ed
marblier1256343marblier
marled95523163mar_l_ed
marlier92614773mar_lier
married104715303mar_ried
marshier1337593marshier
pacified1638363pacified
paddled123612023paddl_ed
paisley1235553paisl_ey
paled85538723pa__l_ed
palier85023563pa__lier
palled94625163pa__lled
pallid93915283pa_lli_d
pallier94417163pa_llier
palmed114314643pa__lmed
palped114513643pa__lped
palsies94420273pals_ies
pandied113913443pa_ndied
paneled10612573panel_ed
panelized2147033panelized
panelled1138963panelled
panfried14134933panfried
panoplied1443413panoplied
pansies94521983pans_ies
pantiled113111593pantiled
paraded114014263par_aded
paraglide1345703paraglide
paraglided1543253paraglided
parallel1047473parallel
paralysed1545743paralysed
paralyzed2445293paralyzed
parasailed1344073parasailed
parasoled1246353parasoled
parbaked1735503parbaked
parboiled1445223parboiled
parceled1338343parceled
parcelled1445783parcelled
parched154013693par_ched
pardie96021443par_die_
pardoned12189333pardoned
pared86946763par___ed
parented11912213parented
parged104922043par__ged
pargeted1238683pargeted
paries84742513par__ies
parities10522973parities
parked134425143par__ked
parkland1545373parkland
parklike1337493parklike
parlayed1435823parlayed
parle75836163par_l_e_
parles86334403par_l_es
parley116718363par_l_ey
parleyed1436243parleyed
parling103823763par_ling
parodies11313693parodies
parole84425253parol_e_
parolee94119643parol_ee
parolees104313983parolees
paroles95025883parol_es
paroling113316213paroling
parotid102915513paroti_d
parred95024073par__red
parrier93717653par_rier
parries93925843par_ries
parroted1158843parroted
parse75236993pars__e_
parsec105914483pars__ec
parser84822373pars__er
parses85534703pars__es
parsing103819553pars_ing
parsleys1335083parsleys
parsnip1146323parsni_p
parsnips1245533parsnips
parted94228683par__ted
partier93520713par_tier
parties93230863par_ties
partlet92720363partl_et
pashed125923143pa_s_hed
passaged1236243passaged
passed94320943pa_s_sed
passepied1442933passepied
pasted94426903pa_s_ted
pastie85525523pa_stie_
pastier94320383pa_stier
pasties94529813pa_sties
patrolled1245713patrolled
patsies93919483pats_ies
paused95114963paus__ed
pearled10411553pear_l_ed
pearlier1037323pear_lier
pearlized2145563pear_lized
periled10316323peril_ed
perilled11410113perilled
perspired1444213perspired
plied85118593p___lied
portlier1038373portlier
presliced1435983presliced
pried84426863p_r__ied
prilled104713003p_rilled
purblind1345163purblind
purfled13248733purfl_ed
purified1438743purified
purled94520753pur_l_ed
purlieu938143pur_lieu
purpled12299783purpl_ed
pursed95220883purs__ed
pursier94012753purs_ier
pursued10388133purs_ued
pusslies1036173pusslies
pyralid1347983pyrali_d
pyrolized2446123pyrolized
rallied83514083ra_llied
rarefied1245913rarefied
rarified1239053rarified
rassled83310453rassl_ed
relied74926233__relied
sallied83316953sa_llied
sparkled15317733sparkl_ed
sparklier1554363sparklier
tallied83314753ta_llied
tarried83914133tar_ried
tarsier74119253tars_ier
varied104817863var__ied
warbled133212163warbl_ed
warsle93112923warsl_e_
warsler10289893warsl_er
warsles103413643warsl_es
warsling12198593warsling
warstled12286123warstled

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.423422437.4
2DLD Change Limit1461621656.65621959.4
3Display Results1651650.0762171.1
 (SQL Overall)1786911657.15524974.3
 
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.