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

82 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
faeces11471312(None) 
faces106439431fa_ces
falces115216001falces
farces115223321farces
fasces114914541fasces
fauces114916151fauces
feces105625361f_eces
aces67645092_a_ces
aedes64625152_aedes
calces104420052calces
daces85030682da_ces
dances95120652dances
fables114921672fables
face96140122fa_ce_
faced117727652fa_ced
facer105525052fa_cer
facers115519442facers
facet106038522fa_cet
facets116316652facets
facies113921592facies
facts107021892fa_cts
fades94932862fa_des
fadges114814032fadges
faecal11359812faecal
faenas94412762faenas
faeries104118992faeries
faiences1337042faiences
fakes126032482fa_kes
fames105735922fa_mes
fancies124018782fancies
fanes84639892fa_nes
farce104925322farce_
farced125216532farced
farcer115016082farcer
farcers124713442farcers
farcies125317882farcies
fares85852872fa_res
farles96025782farles
fashes124524022fashes
fates85139232fa_tes
faucet115816552faucet
faucets12578442faucets
fauves125610422fauves
faves115331422fa_ves
faxes155726652fa_xes
fazes175527212fa_zes
feases95422922feases
feazes184514172feazes
fecks145417852f_ecks
fees76450602f_e_es
feezes184412612feezes
femes105626222f_emes
fences114617112fences
feres86038182f_eres
fetes85630142f_etes
fezes175220022f_ezes
fiances12310672fiances
fices106031162f_ices
fleches153411442fleches
flecks154310802flecks
fleeces12399642fleeces
flees85828752fle_es
flexes164512952flexes
forces114422132forces
frees86131392fre_es
freres94716172freres
fyces139813642f_yces
haeres94017032haeres
hances115621282hances
laces76141762la_ces
lances84824102lances
maces97139962ma_ces
nances83618642nances
nieces84112712nieces
paces96741112pa_ces
peaces106324082peaces
pieces104217272pieces
races74943242ra_ces
rances84625442rances
saices84221802saices
sauces84919502sauces
taces76237802ta_ces

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551822.47033421.5
3Display Results82820.0165125.0
 (SQL Overall)178691822.82963164.0
 
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.