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

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

73 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
refaces12321674(None) 
defaces133213401defaces
prefaces15311061prefaces
reface113616351reface_
refaced133713571refaced
relaces93420881relaces
bifaces1448062bifaces
deface123113862deface_
defaced142910972defaced
defacer132810362defacer
defacers14237992defacers
defames132812252defames
effaces15277272effaces
enfaces122110912enfaces
faces106439432__faces
forefaces1747132forefaces
menaces112715522menaces
peaces106324082pe_aces
preface14510922preface_
prefaced1638422prefaced
prefacer1537982prefacer
prefacers1636292prefacers
prefades1439532prefades
races74943242r__aces
reaches123423202re_aches
reacts83616602re_acts
reales64934122re_ales
reaves94127572re_aves
rebates95123182rebates
recanes93222262recanes
recces10614912re_cces
redacts10510942redacts
redates83423872redates
reduces10513342reduces
refalls103312242refalls
refects124012742refects
refences13311842refences
refiles104122422refiles
refines105426342refines
refires104820312refires
refixes174813172refixes
reflates113115662reflates
reflies104418532reflies
refocus1236972refocus
refracts13137382refracts
reframes1338992reframes
refries104419732refries
refuges115413372refuges
refuses104918552refuses
refutes104515732refutes
regales83520792regales
relace83122152relace_
relaced103517212relaced
relates73731432relates
relaxes143215322relaxes
remakes134116172remakes
remates93827112remates
renames92418052renames
repacks15269542repacks
repaves123513652repaves
replaces123114122replaces
reracks132310532reracks
resales74724902resales
respaces12311042respaces
retacks132210712retacks
retakes113718862retakes
retapes93917422retapes
retaxes143615092retaxes
retraces101417272retraces
rewakes144614982rewakes
rewaxes173911332rewaxes
rubaces1139312rubaces
tenaces92814512tenaces

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671733.25333099.0
3Display Results73730.0302433.3
 (SQL Overall)178691733.65648876.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.