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

264 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
prefaced163842(None) 
preface14510921preface_
prefacer1537981prefacer
prefaces15311061prefaces
prefaded1537821prefaded
refaced133713571_refaced
barefaced1743692barefaced
defaced142910972_defaced
peaced115818912p_e_aced
preached163412062pre_ached
preacted132710942pre_acted
preaged11612332pre_aged
prebaked1737172prebaked
predated12513272predated
prefabbed1942322prefabbed
prefacers1636292prefacers
prefade1339012prefade_
prefades1439532prefades
prefiled143310572prefiled
prefired144310752prefired
prefixed21357702prefixed
prepacked20155652prepacked
prepared132210872prepared
prepaved16177232prepaved
preplaced1676482preplaced
prerace11414122prerace_
presaged1238802presaged
pretaped13339132pretaped
profaned14207972profaned
reface113616352_reface_
refaces123216742_refaces
relaced103517212_relaced
belaced124112153_belaced
braced115420603br__aced
breached163411643bre_ached
breaded115014063bre_aded
breamed124011593bre_amed
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
created104323453cre_ated
cremated133412963cremated
crenated113013913crenated
creviced1634453creviced
deface123113863_deface_
defacer132810363_defacer
defaces133213403_defaces
defamed14309833_defamed
dreaded103612023dre_aded
dreamed114310633dre_amed
effaced16225573_effaced
enfaced13218913_enfaced
faced117727653___faced
foreface1647113foreface_
forefaces1747133forefaces
freaked15399703fre_aked
graced105217903gr__aced
greased93812393gre_ased
greaved12408913gre_aved
grimaced1463313grimaced
menaced122710093_menaced
outfaced14219463outfaced
paced106931683p___aced
palaced124110783p_alaced
paleface1545343paleface_
palefaces1645303palefaces
peace95026083p_e_ace_
peaces106324083p_e_aces
peached154315883p_e_ached
peaked136117403p_e_aked
pealed95322813p_e_aled
pedaled113711893p_edaled
penanced1338163p_enanced
peracid12312993p_eracid
perfected1736643perfected
perfumed1654543perfumed
perfused1445833perfused
pervaded1535373pervaded
petaled103614153p_etaled
phreaked1834493phre_aked
pieced113912103pie__ced
pierced12347593pie_rced
placed114318003p__laced
pleached16338063ple_ached
pleaded113511263ple_aded
pleased103712073ple_ased
pleated103816633ple_ated
pranced123714043pr_anced
prated94924923pr__ated
prayed124815433pr__ayed
preach133613923pre_ac_h
preacher153211373pre_acher
preaches153214893pre_aches
preachy17307313pre_achy
preact103220393pre_ac_t
preacts113211363pre_acts
prearmed1397993prearmed
preaver121011613pre_aver
prebade12310283prebade_
prebake1539093prebake_
prebakes1639013prebakes
precancel1546203precancel
precancer1547093precancer
precede1239653pre__cede
preceded1438293preceded
precised133213413precised
precited133013813precited
precoded1438863precoded
precured1339993precured
predate10616893predate_
predates11615813predates
predicted1538913predicted
predried12309573predried
preed85128123pre___ed
preenacted1544973preenacted
preened103214993pre_ened
prefab1336243prefa__b
prefabs1435163prefa_bs
prefacing17118743prefacing
prefect141011073prefec_t
prefects1598133prefects
prefer113813203pref__er
preferred1555003preferred
prefile123413183prefile_
prefiles133113443prefiles
prefilled1535513prefilled
prefinanced1983183prefinanced
prefire124012813prefire_
prefires134313283prefires
prefixes20389233prefixes
preflame1545913preflame_
prefocus1544743prefocus
prefocused1843443prefocused
preformed17176203preformed
prefranked2042773prefranked
prefund1335733pref_und
prefunded1644693prefunded
pregame1239553pregame_
pregames1339003pregames
preheated1539813preheated
prelacies13310053prelacies
prelacy1437583prelac_y
prelate9519693prelate_
prelates10418573prelates
prelected1439133prelected
preloaded1335923preloaded
preluded1236473preluded
premade12311443premade_
premed114617763pre__med
premised133013193premised
premixed20338013premixed
prename11412643prename_
prenames12311643prenames
prenticed14118063prenticed
preowned1435213preowned
prepack1757643prepac_k
prepacks1836583prepacks
prepaid12310133prepa_id
prepare111913623prepare_
preparer12169643preparer
prepares122014163prepares
prepasted14137673prepasted
prepave14228873prepave_
prepaves15189193prepaves
preplace1488983preplace_
preplaces1578753preplaces
prepped11329903pre_pped
prepriced1676643prepriced
prepuce1337833prepuce_
prepuces1438583prepuces
presage10312293presage_
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
preshaped1745523preshaped
presided12410553presided
presliced1435983presliced
presoaked1635653presoaked
pressed103317313pre_ssed
presumed1337973presumed
pretape113511623pretape_
pretapes122811533pretapes
pretasted12147963pretasted
prettied1159253prettied
pretyped16306123pretyped
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143pre_vued
prewarmed17104563prewarmed
prewarned1594773prewarned
prewashed1843923prewashed
prewired14358473prewired
preyed125313203pre__yed
priced115018883pr__iced
probated13410863probated
produced1456073produced
profane122111863profane_
profaner13197943profaner
profanes132311573profanes
profiled14338523profiled
profited14279973profited
pronated11414053pronated
prorated11513713prorated
raced87635313_r__aced
reached134619083_re_ached
reacted103015713_re_acted
reamed94326123_re_amed
reaped94122453_re_aped
reared75930013_re_ared
reaved104523923_re_aved
rebated103619703_rebated
recaned102817203_recaned
redacted12410243_redacted
redated93120923_redated
reduced11610323_reduced
refected142311663_refected
refed93921923_ref__ed
refeed104717623_ref_eed
refenced1438993_refenced
reffed134712513_ref_fed
refiled114318653_refiled
refined114720003_refined
refired115116993_refired
refixed183611153_refixed
reflated123514293_reflated
refracted1557393_refracted
reframed1437853_reframed
refried113513873_refried
refuged125410873_refuged
refused115114443_refused
refuted114313803_refuted
regaled93615963_regaled
relace83122153_relace_
relaces93420883_relaces
related83327573_related
relaxed153312533_relaxed
relayed113212753_relayed
remated103522473_remated
renamed103114523_renamed
repacked17188743_repacked
repaved133311133_repaved
replaced133211403_replaced
reracked15169123_reracked
resawed113111183_resawed
respaced1338503_respaced
retacked15169273_retacked
retaped103814283_retaped
retaxed153512233_retaxed
retraced111413023_retraced
rewaked153811903_rewaked
rewaxed18409343_rewaxed
surfaced1436063surfaced
terraced11318123terraced
traced94821583tr__aced
treaded95014283tre_aded
treated83618703tre_ated
undefaced1644753undefaced
uneffaced1842573uneffaced
upreached1764083upre_ached
upreared1137073upre_ared
wheyfaced246953wheyfaced
wreaked15369023wre_aked

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.423422437.4
2DLD Change Limit1461622647.86018595.7
3Display Results2642640.1062490.6
 (SQL Overall)1786912648.38921300.6
 
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.