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 “effacers” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
effacers1624423(None) 
effacer15255411effacer_
effaces15277271efface_s
defacers14237992defacers
efface14366672efface__
effaced16225572efface_d
effecters1764322effecters
enfaces122110912enface_s
facers115519442__facers
officers1643802officers
affaires1444303affaires
affairs1334163affa_irs
affecters1763933affecters
affixers2143293affixers
affrayers1842213affrayers
bifaces1448063biface_s
bracers114616703_bracers
defacer132810363defacer_
defaces133213403deface_s
defamers14258523defamers
defeaters13289103defeaters
deflaters13298703deflaters
defoamers15285253defoamers
deforcers15265503deforcers
defrayers1644173defrayers
eagers74523683e__agers
eaters65535953e__aters
effacing1744463effacing
effecter1664773effecter_
effectors1755033effectors
effects1535283effec_ts
effuses1335903effuse_s
elaters74420193e_laters
embracers15105153embracers
empalers12226743empalers
enface112510353enface__
enfaced13218913enface_d
enfevers1444513enfevers
enforcers14215213enforcers
engagers10246553engagers
enhancers1445103enhancers
enlaces92313393enlace_s
enticers10139093enticers
erasers74413943e_rasers
escapers12337413escapers
essayers1133563essayers
evaders1136933e_vaders
exacters1736773e_xacters
facer105525053__facer_
faces106439433__face_s
facets116316653__facets
faders105117463__faders
fakers134219533__fakers
farcers124713443_farcers
farers95924053__farers
fearers104815273_fearers
fencers123810623_fencers
fiacres1237253_fiacres
flakers143613273_flakers
flamers124616363_flamers
flayers133912033_flayers
foamers123812103_foamers
forcers124215713_forcers
framers125113823_framers
fraters103517213_fraters
lacers85225253__lacers
macers105321273__macers
menacers12279313menacers
offerers1434933offerers
offers12349963off__ers
officer1534213officer_
offices1536243office_s
pacers105124543__pacers
placers114515263_placers
prefacers1636293prefacers
racers84725433__racers
refaces123216743reface_s
replacers13266833replacers
retracers11149553retracers
seafarers1244143seafarers
solacers10268893solacers
spacers113813873_spacers
sufficers17204533sufficers
surfacers1444323surfacers
tracers94917843_tracers

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 Filter1786911461620.406440125.6
2DLD Change Limit146162856.81321453.4
3Display Results85850.0302833.3
 (SQL Overall)178691857.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.