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

137 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
pervaded153537(None) 
pervade1337021pervade_
pervader1444861pervader
pervades1437351pervades
evaded1137062_e_vaded
paraded114014262par_aded
persuaded1344372persuaded
pervaders1544432pervaders
prefaded1537822prefaded
abraded1138643abr_aded
aerated85322383aer_ated
arcaded1178973_arcaded
beaded104922423be__aded
beheaded1536373beheaded
beraked144312433ber_aked
berated104422133ber_ated
bereaved1446403bereaved
breaded115014063_breaded
cerated103922473cer_ated
corraded12128293corraded
degraded12288323degraded
deleaded1148333deleaded
derated93623503der_ated
derided102914253der_ided
dreaded103612023_dreaded
enervated1347313enervated
erased74816763_er_ased
eroded84313593_er_oded
evade938183_e_vade_
evader1036813_e_vader
evades1039023_e_vades
graded94919553_gr_aded
headed114020473he__aded
heralded1335443heralded
herbaged1554533herbaged
herded114215643her__ded
invaded12127043_invaded
leaded84221543le__aded
nervate1039533nervate_
nerved104111693nerv__ed
operated11512223oper_ated
overladed1459223overladed
parade94720643par_ade_
parader103914863par_ader
parades104121473par_ades
parbaked1735503parbaked
parkade1437583parkade_
parkades1538273parkades
parlayed1435823parlayed
peaced115818913pe__aced
peaked136117403pe__aked
pealed95322813pe__aled
pedaled113711893pe_daled
peeved124112893peev__ed
pended103819013pe__nded
pennated11299543pennated
peracid12312993per_acid
percale11314093percale_
percales12313803percales
perched154713243per_ched
perdured12287403perdured
perfumed1654543perfumed
perfused1445843perfused
periled10316323per_iled
perilled11410113perilled
periodid1248163periodid
perished14310093perished
perjured18286273perjured
perked134617693per__ked
permeated1439373permeated
permed115217353per__med
permuted1336713permuted
perorated12412473perorated
peroxided2045083peroxided
perpended1546083perpended
persuade1145853persuade_
persuader1244263persuader
persuades1245623persuades
pertained1238503pertained
peruked14367893per_uked
perused103112203per_used
pervading1636303pervading
perverted1546103perverted
pesade9311103pe_sade_
pesades10310903pe_sades
petaled103614153pe_taled
phrased1387383phr_ased
phreaked1834493phreaked
pirated102515613pir_ated
pleaded113511263p_leaded
pomaded13377863p_omaded
portaged12228463portaged
portaled11239203portaled
prated94924923p_r_ated
prayed124815433p_r_ayed
preaged11612333p_reaged
prebade12310283prebade_
prebaked1737173prebaked
preceded1438293preceded
precoded1438863precoded
predated12513273predated
prefaced1638423prefaced
prefade1339013prefade_
prefades1439533prefades
preloaded1335923preloaded
preluded1236473preluded
premade12311443premade_
prepared132210873prepared
prepaved16177233prepaved
presaged1238813presaged
presided12410553presided
pretaped13339133pretaped
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143prev_ued
prided103618033p_r_ided
prodded1257733p_rodded
provided1536843provided
purveyed1743363purveyed
regraded113410763regraded
reinvaded1444073reinvaded
reloaded1059103reloaded
respaded1238133respaded
retreaded1137063retreaded
selvaged1334343selvaged
serenaded11215933serenaded
seriated92717023seriated
serrated92513433serrated
served104616813serv__ed
serviced1435613serviced
terraced11318133terraced
threaded1366323threaded
traded85717683_tr_aded
treaded95014283_treaded
unevaded1336423unevaded
upgraded13215683upgr_aded

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621378.11018022.4
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.56220870.2
 
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.