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

100 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
fauces11491615(None) 
faces106439431fa_ces
faeces114713121faeces
falces115216001falces
farces115223321farces
fasces114914541fasces
faucet115816551faucet
faucets12578441faucets
fauves125610421fauves
sauces84919501sauces
aces67645092_a_ces
aures55137092_aures
calces104420052calces
caucus1039602caucus
caules85927252caules
causes88026472causes
cruces105117542cruces
daces85030682da_ces
dances95120652dances
daubes94913702daubes
deuces94015512deuces
duces86327472_duces
educes94011952educes
fables114921672fables
face96140122fa_ce_
faced117727652fa_ced
facer105525052fa_cer
facers115519442fa_cers
facet106038522fa_cet
facets116316652fa_cets
facies113921592facies
facts107021892fa_cts
fades94932862fa_des
fadges114814022fadges
fakes126032482fa_kes
fames105735922fa_mes
fancies124018782fancies
fanes84639892fa_nes
farce104925322farce_
farced125216532farced
farcer115016082farcer
farcers124713442farcers
farcies125317882farcies
fares85852872fa_res
farles96025782farles
fashes124524022fashes
fates85139232fa_tes
faucal11339962faucal
faucals12326562faucals
faulds10438962faulds
faults94513552faults
faunas94013632faunas
fauns84516752fau_ns
fauve114712072fauve_
faves115331422fa_ves
favuses1336182favuses
faxes155726652fa_xes
fazes175527212fa_zes
feces105625362f_eces
fences114617112fences
fiances12310672fiances
fices106031162f_ices
flues84626922flu_es
flukes135114192flukes
flumes115119732flumes
flutes95421782flutes
fluxes165212932fluxes
forces114422132forces
fucks144419252f_ucks
fucus105515892f_ucus
fumes105224702f_umes
fuses85628422f_uses
fuzes175120222f_uzes
fyces139813642f_yces
gauges85915992gauges
gauzes164710632gauzes
hances115621282hances
jaunces16307422jaunces
laces76141762la_ces
lances84824102lances
launces9329002launces
luces75528432_luces
maces97139962ma_ces
mauves113811552mauves
nances83618642nances
paces96741112pa_ces
pauses84621472pauses
puces94924632_puces
races74943242ra_ces
rances84625442rances
saices84221802saices
sauce75121652sauce_
sauced93913302sauced
saucer84314102saucer
saucers93712132saucers
sauchs115112232sauchs
sautes63924912sautes
taces76237802ta_ces
taupes8212672taupes
truces84916332truces

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.1061685764.2
2DLD Change Limit825511002.67330883.3
3Display Results1001000.0303333.3
 (SQL Overall)1786911002.80963613.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.