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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
sauce7512165(None) 
saice75424051saice
sauced93913301sauced
saucer84314101saucer
sauces84919501sauces
sauch104918771sauch
saucy104615161saucy
saute55028081saute
ace59656832_a_ce
cause75225352cause
dace76934922da_ce
dance85223132dance
daube85015302daube
deuce84517492deuce
douce85518422douce
duce76933502_duce
educe84313452educe
face96140122fa_ce
farce104925322farce
fauces114916152fauces
faucet115816552faucet
fauve114712072fauve
gauche1238562gauche
gauge76117902gauge
gauze155712972gauze
hance105424152hance
haute89521612haute
jaunce15367432jaunce
lace66848472la_ce
lance75126722lance
launce8469182launce
luce65132572_luce
mace87345792ma_ce
mauve104013272mauve
nance74721842nance
pace86345772pa_ce
pause75021832pause
puce85127882_puce
race66746262ra_ce
rance75028512rance
sabe66140572sa_be
sable74732162sable
sabre74821502sabre
sac57452862sa_c_
sack105337312sa_ck
sacs65739072sa_cs
sade55544472sa_de
sadhe94815132sadhe
sae38365182sa__e
safe75930952sa_fe
sage55044592sa_ge
saices84221802saices
sake85244962sa_ke
sale44959702sa_le
salute64418022salute
salve85022132salve
same65245642sa_me
sane45954342sa_ne
saree55044662saree
sarge65531132sarge
sate45556102sa_te
sau36356572sau__
saucers93712132saucers
sauchs115112232sauchs
saucier9810282saucier
sauger74316252sauger
saugh95318402saugh
saul45836522sau_l
sauls55128122sauls
sault55834962sault
sauna54117552sauna
saurel6511992saurel
saury84317222saury
sauted74119602sauted
sautes63924912sautes
save75741362sa_ve
scarce104013632scarce
scute75520942scute
seance83716692seance
seduce9610022seduce
shuck144314532shuck
shute84520352shute
sice65545592s_ice
since75024172since
slice74925822slice
slue45332192slu_e
sluice849512sluice
snuck114411912snuck
source8410672source
souse56530772souse
space95325672space
spice95528812spice
spruce103910872spruce
spue66025522spu_e
spume95817312spume
stance84316912stance
stuck114515772stuck
stupe75217752stupe
suave83519872suave
such96424812s_uch
suck106131732s_uck
sucre75019102s_ucre
sue35651462s_u_e
supe65932762s_upe
sure45447412s_ure
syce95820282s_yce
tace65342512ta_ce
taupe7314162taupe
truce75118692truce
usance858012usance
usaunce9103382usaunce

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001111.48336277.8
3Display Results1111110.0333363.6
 (SQL Overall)1786911111.81298615.3
 
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.