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

260 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
prefaded153782(None) 
prefaced1638421prefaced
prefade1339011prefade_
prefades1439531prefades
breaded115014062bre_aded
dreaded103612022dre_aded
pervaded1535362pervaded
pleaded113511262ple_aded
preaged11612332pre_aged
prebade12310282prebade_
prebaked1737172prebaked
preceded1438282preceded
precoded1438862precoded
predated12513272predated
prefabbed1942322prefabbed
preface14510922preface_
prefacer1537982prefacer
prefaces15311062prefaces
prefiled143310572prefiled
prefired144310752prefired
prefixed21357692prefixed
prefunded1644692prefunded
preloaded1335922preloaded
preluded1236462preluded
premade12311442premade_
prepared132210862prepared
prepaved16177222prepaved
presaged1238802presaged
presided12410552presided
pretaped13339132pretaped
profaned14207972profaned
refaced133713572_refaced
treaded95014282tre_aded
arcaded1178973ar_caded
barefaced1743693barefaced
beaded104922423_be_aded
breamed124011593bre_amed
brigaded1344573brigaded
brocaded1436353brocaded
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
created104323443cre_ated
cremated133412963cremated
crenated113013913crenated
crusaded1244233crusaded
defaced142910973_defaced
defamed14309833_defamed
dreamed114310633dre_amed
evaded1137063__evaded
faded105025243___faded
freaked15399703fre_aked
graded94919553gr__aded
greased93812393gre_ased
greaved12408913gre_aved
grenade938413grenade_
grenades1038433grenades
headed114020473_he_aded
kneaded13146473kne_aded
leaded84221543_le_aded
paraded114014263p_araded
peaced115818913p_e_aced
peaked136117403p_e_aked
pealed95322803p_e_aled
pedaled113711883p_edaled
pended103819013p_e_nded
perfumed1654533perfumed
perfused1445823perfused
persuaded1344363persuaded
pervade1337023pervade_
pervader1444863pervader
pervades1437353pervades
pesade9311103p_esade_
pesades10310903p_esades
petaled103614143p_etaled
phreaked1834493phre_aked
pleader103511753ple_ader
pleased103712073ple_ased
pleated103816633ple_ated
pleiades1145753pleiades
pomaded13377863p_omaded
prated94924923pr__ated
prayed124815433pr__ayed
preached163412063preached
preacted132710943preacted
prearmed1397993prearmed
preaver121011613pre_aver
prebake1539093prebake_
prebakes1639013prebakes
preboarded1663893preboarded
precede1239643precede_
precedes13310703precedes
precised133213413precised
precited133013813precited
precluded1544213precluded
precode12311853precode_
precodes13711573precodes
precured1339993precured
predate10616893predate_
predates11615813predates
predried12309573predried
preed85128113pre___ed
preened103214983pre_ened
prefab1336243prefa__b
prefabs1435163prefa_bs
prefacers1636293prefacers
prefading16149033prefading
prefer113813203pref__er
preferred1555003preferred
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefire124012813prefire_
prefires134313283prefires
prefixes20389233prefixes
preflame1545913preflame_
preformed17176203preformed
prefranked2042773prefranked
prefund1335733pref_und
pregame1239553pregame_
pregames1339003pregames
preguided1443923preguided
prehandled1743633prehandled
preharden15104823preharden
preheated1539813preheated
prejudged2142753prejudged
prelate9519693prelate_
prelates10418573prelates
prelude1038013prelude_
preluder1135733preluder
preludes1137833preludes
premed114617753pre__med
premised133013193premised
premixed20338003premixed
premolded1544683premolded
prename11412643prename_
prenames12311643prenames
preorder1136463preorder
preowned1435213preowned
prepacked20155643prepacked
prepaid12310133prepa_id
prepare111913623prepare_
preparer12169643preparer
prepares122014163prepares
prepasted14137663prepasted
prepave14228873prepave_
prepaves15189193prepaves
preplaced1676473preplaced
prepped11329893pre_pped
prerace11414123prerace_
preradio1145723preradio
presage10312293presage_
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
preshaped1745523preshaped
preside10715613preside_
presider11410423presider
presides11414913presides
presoaked1635653presoaked
pressed103317313pre_ssed
presumed1337973presumed
pretape113511623pretape_
pretapes122811533pretapes
pretasted12147963pretasted
pretended1337193pretended
prettied1159253prettied
pretyped16306123pretyped
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143pre_vued
prewarmed17104563prewarmed
prewarned1594773prewarned
prewashed1843923prewashed
prewired14358473prewired
preyed125313193pre__yed
prided103618033pr__ided
probated13410863probated
prodded1257733pr_odded
profane122111863profane_
profaner13197943profaner
profanes132311573profanes
profiled14338523profiled
profited14279973profited
promenaded1683633promenaded
pronated11414053pronated
prorated11513713prorated
provided1536843provided
readd74617133_re_ad_d
readded103310733_readded
reader73628293_re_ader
readied93316623_re_adied
reamed94326123_re_amed
reaped94122453_re_aped
reared75930013_re_ared
reaved104523923_re_aved
rebated103619703_rebated
recaned102817203_recaned
receded112713043_receded
recoded113115033_recoded
redated93120923_redated
redded94019543_re_dded
reded74829113_re__ded
reeded84022563_re_eded
reface113616353_reface_
refaces123216743_refaces
refed93921923_ref__ed
refeed104717623_ref_eed
reffed134712513_ref_fed
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refixed183611153_refixed
reflated123514293_reflated
refolded1337063_refolded
reframed1437853_reframed
refried113513873_refried
refuged125410873_refuged
refunded1336953_refunded
refused115114443_refused
refuted114313803_refuted
regaled93615963_regaled
regarded11279803_regarded
regraded113410763_regraded
relaced103517213_relaced
relanded102410463_relanded
related83327573_related
relaxed153312523_relaxed
relayed113212753_relayed
reloaded1059103_reloaded
remade94316983_remade_
remanded123011323_remanded
remated103522473_remated
renamed103114523_renamed
rended84524103_re_nded
repaved133311133_repaved
resawed113111183_resawed
resided95217703_resided
respaded1238133_respaded
retaped103814283_retaped
retarded102410753_retarded
retaxed153512233_retaxed
rewaked153811903_rewaked
rewarded13229523_rewarded
rewaxed18409343_rewaxed
serenaded11215933serenaded
spreader1137473spre_ader
steaded92811673ste_aded
threaded1366323thre_aded
traded85717683tr__aded
treader84113833tre_ader
treadled1067123tre_adled
treated83618703tre_ated
trended94011763tre_nded
unevaded1336423unevaded
unfaded123111733_unfaded
upreared1137073upre_ared
wreaked15369023wre_aked

Search took 10 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.1561145455.1
2DLD Change Limit1461622608.51317169.3
3Display Results2602600.330787.9
 (SQL Overall)1786912608.99919856.8
 
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.