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

182 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
effaces1527727(None) 
efface14366671efface_
effaced16225571effaced
effacer15255411effacer
effacers16244231effacers
enfaces122110911enfaces
bifaces1448062bifaces
defaces133213402defaces
effects1535282effects
effuses1335902effuses
enface112510352enface_
enfaced13218912enfaced
enlaces92313392enlaces
faces106439432__faces
offices1536242offices
refaces123216742refaces
aces67645093___aces
affaires1444303affaires
affairs1334163affairs
affects1535393affects
affiances1745153affiances
affiches1945233affiches
affines1339483affines
affixes2035503affixes
anlaces92313733anlaces
biface1358103biface_
boraces113716853boraces
braces108427773_braces
catfaces1536963catfaces
daces85030683__daces
deface123113863deface_
defaced142910973defaced
defacer132810363defacer
defacers14237993defacers
defames132812253defames
defences1439633defences
defiances1557033defiances
deflates123013943deflates
deforces14248403deforces
dogfaces1554143dogfaces
earaches13411313earaches
eases56041613e__ases
eaves85231993e__aves
ectases92911673ectases
edifices1454863edifices
educes94011953e_duces
effable15106673effable
effacing1744463effacing
effect1437443effec_t
effected1744993effected
effecter1664773effecter
effecters1764323effecters
effete1235183effete_
efficacies2052963efficacies
effigies1543513effigies
effluxes2142453effluxes
efforts1334703efforts
effs105114033eff___s
effulges1542603effulges
effuse1234963effuse_
effused1434143effused
elates65032363e_lates
eluates72014683eluates
embraces14128873embraces
empales112411433empales
emplaces1438413emplaces
enacts84012973e_nacts
enates64026433e_nates
encages103313783encages
encases93116053encases
enflames1357043enflames
enforces13208013enforces
enframes1357453enframes
engages92912493engages
enhances1339293enhances
enlace82213233enlace_
enlaced102410523enlaced
enrages83114853enrages
entases72816273entases
entices91616333entices
epacts105010393e_pacts
equates162012323equates
erases64425403e_rases
ergates8314493ergates
escapes113811673escapes
estates74520183estates
etapes85415293e_tapes
ethanes103713513ethanes
evades1039023e_vades
evinces1237803evinces
exacts15359613e_xacts
exhales1737143exhales
eyases94513683e_yases
face96140123__face_
faced117727653__faced
facer105525053__facer
facers115519443__facers
facet106038523__facet
facets116316653__facets
facies113921593__facies
facts107021893__facts
fades94932863__fades
faeces114713123_faeces
fakes126032483__fakes
falces115216003_falces
fames105735923__fames
fanes84639893__fanes
farces115223323_farces
fares85852873__fares
fasces114914543_fasces
fates85139233__fates
fauces114916153_fauces
faves115331423__faves
faxes155726653__faxes
fazes175527213__fazes
feases95422923_feases
feazes184514173_feazes
feces105625363__feces
females12310663females
fences114617113_fences
fiacres1237253_fiacres
fiances12310673_fiances
fices106031163__fices
flacks154114533_flacks
flakes134118873_flakes
flames114723693_flames
flanes94522423_flanes
flares94521703_flares
flaxes165015353_flaxes
forces114422133_forces
fracas11311993_fracas
frames115119863_frames
fyces139813643__fyces
glaces94218033_glaces
graces94523493_graces
hyraces1537913hyraces
infares10313023infares
inlaces92512903inlaces
laces76141763__laces
leafages1244623leafages
maces97139963__maces
menaces112715523menaces
offals1235893offa_ls
offences1645023offences
office1435693office_
officer1534213officer
officers1643803officers
outfaces132311393outfaces
paces96741113__paces
palaces114216463palaces
peaces106324083_peaces
places104323703_places
pomaces132712123pomaces
prefaces15311063prefaces
races74943243__races
reface113616353reface_
refaced133713573refaced
refences13311843refences
reflates113115663reflates
refracts13137383refracts
reframes1338993reframes
relaces93420883relaces
replaces123114123replaces
respaces12311043respaces
retraces101417273retraces
rubaces1139313rubaces
serfages1238233serfages
solaces93116133solaces
spaces104722633_spaces
suffices16208183suffices
surfaces1338673surfaces
taces76237803__taces
tenaces92814513tenaces
terraces102712253terraces
traces85329933_traces
uneffaced1842573uneffaced
unifaces1346393unifaces
unlaces92513623unlaces
vendaces1457183vendaces
vivaces1536413vivaces
welfares1445543welfares
wheyfaces2351523wheyfaces

Search took 8 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 Limit1340271826.76319817.7
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.24924650.4
 
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.