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

168 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
efface1436667(None) 
effaced16225571effaced
effacer15255411effacer
effaces15277271effaces
enface112510351enface
biface1358102biface
deface123113862deface
effable15106672effable
effacers16244232effacers
effect1437442effect
effete1235182effete
effuse1234962effuse
enfaced13218912enfaced
enfaces122110912enfaces
enlace82213232enlace
face96140122__face
office1435692office
reface113616352reface
ace59656833___ace
affable15117403affable
affair1234353affair
affaire1344463affaire
affect1448903affect
affiance1645653affiance
affiche1844313affiche
affine12310503affine
aflame1138723aflame
anlace82513923anlace
apace94718383_apace
bifaces1448063bifaces
brace95629273_brace
catface1436763catface
dace76934923__dace
defaced142910973defaced
defacer132810363defacer
defaces133213403defaces
defame123212433defame
defence1339893defence
defiance1477633defiance
deflate113613943deflate
deforce13267243deforce
dogface1454053dogface
each95530583e__ach
earache1239323earache
ease45042333e__ase
eave75733583e__ave
edifice1344933edifice
educe84313453e_duce
eff96128623eff___
effacing1744463effacing
effected1744993effected
effecter1664773effecter
effects1535283effects
efficacy2152523efficacy
effigy1642213effigy
efflux1942003efflux
effort1238623effort
effs105114033eff__s
effulge1442473effulge
effused1434143effused
effuses1335903effuses
elate55335883e_late
eluate62315433eluate
embrace1388893embrace
empale102611263empale
emplace1338263emplace
enact73525363e_nact
enate54428153e_nate
encage93713503encage
encase83714363encase
enflame1236573enflame
enforce12237423enforce
enframe1247363enframe
engage82812103engage
enhance1239693enhance
enlaced102410523enlaced
enlaces92313393enlaces
enrage72715073enrage
entice81316863entice
epact94921533e_pact
equate152012463equate
erase54925493e_rase
ergate7315143ergate
escape103811663escape
estate64719763estate
etape74413703e_tape
ethane94613243ethane
evade938183e_vade
evince1137763evince
exact143516933e_xact
exhale1636873exhale
faced117727653__faced
facer105525053__facer
faces106439433__faces
facet106038523__facet
fact97142543__fact
fade85736343__fade
fake115534943__fake
fame95639393__fame
fane75343573__fane
farce104925323_farce
fare76354463__fare
fate75444283__fate
fave105532963__fave
faze165630043__faze
fease84824873_fease
feaze175216313_feaze
female11310553female
fence105319913_fence
fiacre1137623_fiacre
fiance11310743_fiance
fice95737113__fice
flack144519413_flack
flake125119973_flake
flame105124443_flame
flare84823633_flare
force105324273_force
frae75330473_fra_e
frame105821803_frame
fyce126316833__fyce
glace87420153_glace
grace85124543_grace
infare9313083infare
inlace82513043inlace
lace66848473__lace
leafage1194573leafage
mace87345793__mace
menace103216943menace
offal1136243offa_l
offals1235893offals
offence1545353offence
officer1534213officer
offices1536243offices
outface123011973outface
pace86345773__pace
palace104516913palace
peace95026083_peace
place94824613_place
pomace123111913pomace
preface14510923preface
race66746263__race
refaced133713573refaced
refaces123216743refaces
refence12312233refence
reflate103516263reflate
refract121311603refract
reframe1239393reframe
relace83122153relace
replace113214283replace
respace11310913respace
retrace91417343retrace
rubace10310173rubace
serfage1138403serfage
solace83415823solace
space95325673_space
suffice15197573suffice
surface1238653surface
tace65342513__tace
tenace82715693tenace
terrace93311843terrace
trace75829613_trace
uneffaced1842573uneffaced
uniface1236953uniface
unlace82215173unlace
vendace1357363vendace
vivace1436553vivace
welfare1335713welfare
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 Filter1786911127160.373479064.3
2DLD Change Limit1127161685.65619928.6
3Display Results1681680.0632666.7
 (SQL Overall)1786911686.09229332.1
 
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.