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

291 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
prefaces1531106(None) 
preface14510921preface_
prefaced1638421prefaced
prefacer1537981prefacer
prefacers1636291prefacers
prefades1439531prefades
refaces123216741_refaces
defaces133213402_defaces
forefaces1747132forefaces
palefaces1645302palefaces
peaces106324082p_e_aces
preaches153214892pre_aches
preacts113211362pre_acts
prebakes1639012prebakes
predates11615812predates
prefabs1435162prefa_bs
prefade1339012prefade_
prefaded1537822prefaded
prefects1598132prefects
prefiles133113442prefiles
prefires134313282prefires
prefixes20389232prefixes
prefocus1544742prefocus
pregames1339002pregames
prelacies13310052prelacies
prelates10418572prelates
prenames12311642prenames
prepacks1836582prepacks
prepares122014162prepares
prepaves15189192prepaves
preplaces1578752preplaces
prepuces1438582prepuces
prerace11414122prerace_
presages11312202presages
presales10315262presales
pretapes122811532pretapes
profanes132311572profanes
reface113616352_reface_
refaced133713572_refaced
relaces93420882_relaces
amesaces1246693amesaces
artefacts1443153artefacts
barefaced1743693barefaced
bifaces1448063_bifaces
braces108427773br__aces
breaches153714123bre_aches
brewages1436383brewages
catfaces1536963catfaces
creases94020963cre_ases
creates95225203cre_ates
cremates124216003cremates
crevices1536713crevices
deface123113863_deface_
defaced142910973_defaced
defacer132810363_defacer
defacers14237993_defacers
defames132812253_defames
dogfaces1554143dogfaces
effaces15277273_effaces
enfaces122110913_enfaces
faces106439433___faces
foreface1647113foreface_
graces94523493gr__aces
greases84816713gre_ases
greaves113311443gre_aves
grenades1038433grenades
grimaces1355383grimaces
menaces112715523_menaces
orifices1346483orifices
outfaces132311393outfaces
paces96741113p___aces
palaces114216463p_alaces
paleface1545343paleface_
peace95026083p_e_ace_
peaced115818913p_e_aced
peaches144120053p_e_aches
peages94321853p_e_ages
peases85229473p_e_ases
peerages1189893peerages
pelages10714613p_elages
penances12312443p_enances
penates93321603p_enates
percales12313803percales
perfects15107353perfects
perfumes1555893perfumes
perfuses1358663perfuses
pervades1437353pervades
pesades10310903p_esades
phenates13611583phenates
pieces104217273pie__ces
pierces113411193pie_rces
pinnaces12268863pinnaces
places104323703p__laces
pleaches153210433ple_aches
pleases94515483ple_ases
pleiades1145753pleiades
pomaces132712123p_omaces
postfaces1656273postfaces
praefects1642873praefects
prances113618773pr_ances
prases84429023pr__ases
prates84633163pr__ates
praxes156215183pr__axes
preach133613923pre_ac_h
preached163412063pre_ached
preacher153211373pre_acher
preachers16339573pre_achers
preachy17307313pre_achy
preact103220393pre_ac_t
preacted132710943pre_acted
preaged11612333pre_aged
preamps1336613pre_amps
prearms11369173pre_arms
preaver121011613pre_aver
preavers13910263pre_avers
prebade12310283prebade_
prebake1539093prebake_
prebaked1737173prebaked
precancel1546203precancel
precancels1644063precancels
precancer1547093precancer
precancers1645253precancers
precasts1239453precasts
precedes13310713precedes
precess11310863pre__cess
precipes143212213precipes
precis103416703pre__cis
precises123218333precises
precodes13711573precodes
precures12312903precures
predaceous1553943predaceous
predate10616893predate_
predated12513273predated
predawns1444363predawns
predicts1339613predicts
predries112714383predries
preemies12512193preemies
preenacts1345843preenacts
prees75937173pre___es
prefab1336243prefa__b
prefabbed1942323prefabbed
prefacing17118743prefacing
prefascist1753143prefascist
prefect141011073prefec_t
prefer113813203pref__er
prefers123713333pref_ers
prefile123413183prefile_
prefiled143310573prefiled
prefinances1875013prefinances
prefire124012813prefire_
prefired144310753prefired
prefixed21357703prefixed
preflame1545913preflame_
prefocuses1744243prefocuses
preforms1537403preforms
prefranks1862993prefranks
prefunds1454693prefunds
pregame1239553pregame_
prelacy1437583prelac_y
prelate9519693prelate_
prelects1299723prelects
prelives13310383prelives
preludes1137833preludes
premade12311443premade_
premies113823063pre_mies
premises123018273premises
premixes193110083premixes
prename11412643prename_
prentices131111903prentices
prepack1757643prepac_k
prepacked20155653prepacked
prepare111913623prepare_
prepared132210873prepared
preparer12169643preparer
preparers13197673preparers
prepastes13128823prepastes
prepave14228873prepave_
prepaved16177233prepaved
prepays1437483prepa_ys
preplace1488983preplace_
preplaced1676483preplaced
preppies1149693preppies
preprices1569263preprices
prepubes1436053prepubes
prepuce1337833prepuce_
presage10312293presage_
presaged1238803presaged
presager1138443presager
presagers1236943presagers
presale9416353presale_
presences132113793presences
preshapes1667093preshapes
presides11414913presides
preslices1338213preslices
presses93523153pre_sses
presumes1239843presumes
pretape113511623pretape_
pretaped13339133pretaped
pretastes11119423pretastes
pretences132312613pretences
pretties10615133pretties
pretypes15337263pretypes
prevails1337663prevails
prevalues1445323prevalues
previses133814283previses
prevues1239263pre_vues
prewarms15406733prewarms
prewarns13456943prewarns
prewashes1744753prewashes
prewires133811013prewires
prexes154915953pre__xes
prexies163415003pre_xies
prezes173614693pre__zes
prices104524543pr__ices
primacies1548453primacies
primages13159273primages
primates121515933primates
princes113015143pr_inces
privacies1646803privacies
privates131812373privates
probates12414283probates
produces1347903produces
profane122111863profane_
profaned14207973profaned
profaner13197943profaner
profaners14256213profaners
profiles133211233profiles
pronates10418373pronates
propanes122415823propanes
prorates10418073prorates
protases102115033protases
races74943243_r__aces
reaches123423203_re_aches
reacts83616603_re_acts
reales64934123_re_ales
reaves94127573_re_aves
rebates95123183_rebates
recanes93222263_recanes
recces10614913_re_cces
redacts10510943_redacts
redates83423873_redates
reduces10513343_reduces
refalls103312243_refalls
refects124012743_refects
refences13311843_refences
refiles104122423_refiles
refines105426343_refines
refires104820313_refires
refixes174813173_refixes
reflates113115663_reflates
reflies104418533_reflies
refocus1236973_refocus
refracts13137383_refracts
reframes1338993_reframes
refries104419733_refries
refuges115413373_refuges
refuses104918553_refuses
refutes104515733_refutes
regales83520793_regales
relace83122153_relace_
relaced103517213_relaced
relates73731433_relates
relaxes143215323_relaxes
remakes134116173_remakes
remates93827113_remates
renames92418053_renames
repacks15269543_repacks
repaves123513653_repaves
replaces123114123_replaces
reracks132310533_reracks
resales74724903_resales
respaces12311043_respaces
retacks132210713_retacks
retakes113718863_retakes
retapes93917423_retapes
retaxes143615093_retaxes
retraces101417273_retraces
rewakes144614983_rewakes
rewaxes173911333_rewaxes
rubaces1139313_rubaces
serfages1238233serfages
surfaces1338673surfaces
tenaces92814513_tenaces
terraces102712253terraces
traces85329933tr__aces
treacles1039703tre_acles
typefaces1942523typefaces
unifaces1346393unifaces
upreaches1654633upre_aches
ureases74416723ure_ases
wheyfaces2351523wheyfaces

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 Limit1461622918.42017358.9
3Display Results2912910.1262309.5
 (SQL Overall)1786912918.95219961.0
 
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.