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

283 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
preface1451092(None) 
prefaced1638421prefaced
prefacer1537981prefacer
prefaces15311061prefaces
prefade1339011prefade
prerace11414121prerace
reface113616351_reface
deface123113862_deface
foreface1647112foreface
paleface1545342paleface
peace95026082p_e_ace
preach133613922pre_ach
preact103220392pre_act
prebade12310282prebade
prebake1539092prebake
predate10616892predate
prefab1336242prefa_b
prefabs1435162prefabs
prefacers1636292prefacers
prefaded1537822prefaded
prefades1439532prefades
prefect141011072prefect
prefile123413182prefile
prefire124012812prefire
preflame1545912preflame
pregame1239552pregame
prelacy1437582prelacy
prelate9519692prelate
premade12311442premade
prename11412642prename
prepack1757642prepack
prepare111913622prepare
prepave14228872prepave
preplace1488982preplace
prepuce1337832prepuce
presage10312292presage
presale9416352presale
pretape113511622pretape
profane122111862profane
refaced133713572_refaced
refaces123216742_refaces
relace83122152_relace
amesace1147733amesace
areae55229743are_a_e
artefact1345183artefact
barefaced1743693barefaced
biface1358103_biface
brace95629273br__ace
breach134213723bre_ach
brewage1347183brewage
catface1436763catface
crease85519573cre_ase
create85126383cre_ate
cremate113816183cremate
crenate93317113crenate
crevice1436153crevice
defaced142910973_defaced
defacer132810363_defacer
defaces133213403_defaces
defame123212433_defame
dogface1454053dogface
efface14366673_efface
enface112510353_enface
face96140123___face
forefaces1747133forefaces
grace85124543gr__ace
grease75416233gre_ase
greave104611493gre_ave
grenade938413grenade
grimace1255083grimace
menace103216943_menace
orifice1246343orifice
outface123011973outface
pace86345773p___ace
palace104516923p_alace
palefaces1645303palefaces
peaced115818913p_e_aced
peaces106324083p_e_aces
peach125422493p_e_ach
peage84723573p_e_age
pease75231113p_e_ase
pedate93117763p_edate
peerage1089803peerage
pelage9515363p_elage
penance11313443p_enance
pence94924453p_e_nce
percale11314093percale
perfect141010833perfect
perforce1544963perforce
perfume1446503perfume
perfuse1247663perfuse
pervade1337023pervade
pesade9311103p_esade
phenate12412203phenate
piece96717993pie__ce
pierce104010393pie_rce
pinnace113510313pinnace
place94824613p__lace
pleach134211243ple_ach
please84315733ple_ase
pomace123111913p_omace
postface1566123postface
praefect1544773praefect
prance104318573pr_ance
prase76128753pr__ase
prate75135983pr__ate
preached163412063pre_ached
preacher153211373pre_acher
preaches153214893pre_aches
preachy17307313pre_achy
preacted132710943pre_acted
preacts113211363pre_acts
preaged11612333pre_aged
preamp1238993pre_amp
prearm104512353pre_arm
preaver121011613pre_aver
prebaked1737173prebaked
prebakes1639013prebakes
precancel1546203precancel
precancer1547093precancer
precast11314853precast
precava1445093precava
precavae1544813precavae
precede1239653precede
precipe133012123precipe
precise113518173precise
precode12311853precode
precure11312553precure
predated12513273predated
predates11615813predates
predawn1335353predawn
predict12315323predict
predive13511083predive
pree67044733pre___e
preemie11310563preemie
preenact12410183preenact
prefabbed1942323prefabbed
prefacing17118743prefacing
prefects1598133prefects
prefer113813203pref_er
prefers123713333prefers
prefiled143310573prefiled
prefiles133113443prefiles
prefinance1795443prefinance
prefired144310753prefired
prefires134313283prefires
prefix18356853pref_ix
prefixed21357703prefixed
prefixes20389233prefixes
prefocus1544743prefocus
preform1439613preform
prefrank1764233prefrank
prefroze2264673prefroze
prefund1335733prefund
pregames1339003pregames
prelacies13310053prelacies
prelates10418573prelates
prelaw1139103prela_w
prelect111013833prelect
prelife1279943prelife
prelude1038013prelude
preman104117453prema_n
premie103617993pre_mie
premise113818553premise
premune1138933premune
prenames12311643prenames
prentice121012353prentice
prepacked20155653prepacked
prepacks1836583prepacks
prepaid12310133prepaid
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepaste12139083prepaste
prepaved16177233prepaved
prepaves15189193prepaves
prepay13310313prepa_y
prepays1437483prepays
preplaced1676483preplaced
preplaces1578753preplaces
preppie1058093preppie
preprice1488873preprice
prepuces1438583prepuces
prerock1536723prerock
presa74319043presa__
presaged1238803presaged
presager1138443presager
presages11312203presages
presales10315263presales
prese75228383pre__se
presence122213513presence
preshape1537533preshape
preside10715613preside
preslice1258623preslice
presume11310303presume
pretaped13339133pretaped
pretapes122811533pretapes
pretaste10139523pretaste
pretax152310193preta_x
pretence122312123pretence
pretype14387483pretype
prevail1238243prevail
prevalue1345073prevalue
previse123713793previse
prevue1179163pre_vue
prewar114712583prewa_r
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
prewire124311143prewire
price93725413pr__ice
primacy1635603primacy
primage12169143primage
primate111516283primate
prince104114763pr_ince
privacy1744233privacy
private121513263private
probate11414483probate
produce1267513produce
profaned14207973profaned
profaner13197943profaner
profanes132311573profanes
profile123211153profile
profuse1237153profuse
prolate9419793prolate
pronate9418873pronate
propane112716153propane
prorate9418733prorate
race66746263_r__ace
reach105123883_re_ach
react74634333_re_act
reave84528023_re_ave
rebate84424113_rebate
recane83022873_recane
recce9514563_re_cce
redact9419043_redact
redate74124683_redate
reduce9713253_reduce
refall94314393_refall
refect114319333_refect
refence12312233_refence
refile95122373_refile
refine95225693_refine
refire95419473_refire
reflate103516263_reflate
refract121311603_refract
reframe1239393_reframe
refuge105312613_refuge
refuse94817513_refuse
refute95515703_refute
regale74821453_regale
regave104713383_regave
relaced103517213_relaced
relaces93420883_relaces
relate64033633_relate
remade94316983_remade
remake124016113_remake
remate84428683_remate
rename82718813_rename
repack142412163_repack
repave114813873_repave
replace113214283_replace
rerack122513163_rerack
resale64025543_resale
respace11310913_respace
retack122612823_retack
retake104718533_retake
retape83917683_retape
retrace91417343_retrace
rewake135218463_rewake
rubace10310173_rubace
serfage1138403serfage
surface1238653surface
tenace82715693_tenace
terrace93311843terrace
trace75829613tr__ace
treacle939973tre_acle
trefah1235093trefa_h
typeface1842423typeface
uniface1236953uniface
upreach1444693upre_ach
urease64516993ure_ase
wheyface2261553wheyface

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272836.22021547.7
3Display Results2832830.1102572.7
 (SQL Overall)1786912836.73626527.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.