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

154 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
sautes6392491(None) 
salutes73716251salutes
sates54949321sa_tes
sauces84919501sauces
saute55028081saute_
sauted74119601sauted
scutes85219191scutes
shutes93518221shutes
acutes83917722acutes
antes56334322_antes
ates45047922_a_tes
aures55137092_aures
autos56523322_autos
bastes85330382bastes
bates75846342ba_tes
brutes86118682brutes
butes714535872_butes
cartes86239472cartes
castes85631862castes
cates75951892ca_tes
caules85927252caules
causes88026472causes
chutes114615772chutes
cutes79438322_cutes
dates65639152da_tes
daubes94913702daubes
dauted84114932dauted
dauties83315762dauties
dauts67822242daut_s
elutes64020312elutes
fates85139232fa_tes
fauces114916152fauces
fauves125610422fauves
flutes95421782flutes
gates65939512ga_tes
gauges85915992gauges
gauzes164710632gauzes
glutes74517672glutes
hastes95727072hastes
hates86742572ha_tes
haute89521612haute_
jutes125125132_jutes
lattes65324202lattes
lutes55836662_lutes
mantes84430782mantes
mates75251362ma_tes
mattes85624532mattes
mauts75927192maut_s
mauves113811552mauves
mutes75033782_mutes
nates55238332na_tes
pastes85233912pastes
pates76047892pa_tes
pauses84621472pauses
rates55352012ra_tes
routes66129312routes
sabes76437462sa_bes
sables85026692sables
sabres85520862sabres
sades65239892sa_des
sadhes104715372sadhes
safes85226722sa_fes
sages65339062sa_ges
saices84221802saices
sakes95540752sa_kes
sales56055592sa_les
salted74121202salted
salter64325082salter
salters73622252salters
saltest71916512saltest
salties73725772salties
salts55431882salt_s
salute64418022salute_
saluted84511712saluted
saluter73512452saluter
saluters8319862saluters
salves94221762salves
samites93118712samites
sanes55649072sa_nes
sanies63031952sanies
santos64421832santos
sapotes9313942sapotes
sarees65329942sarees
sarges75128592sarges
sashes94728482sashes
sasses64124392sasses
sate45556102sa_te_
sated66238532sa_ted
satem76021462sa_tem
satis55633682sa_tis
sauce75121652sauce_
sauced93913302sauced
saucer84314102saucer
saucers93712132saucers
sauchs115112232sauchs
sauger74316252sauger
saugers83914052saugers
saughs104812052saughs
sauls55128122sau_ls
saults65816172saults
saunas63915432saunas
saunter72913452saunter
saunters82911752saunters
saurel6511992saurel
saurels749302saurels
sauries72821622sauries
sauteed8349612sauteed
savates10312952savates
saves85838632sa_ves
saxes125229342sa_xes
scute75520942scute_
scuts74522522scut_s
shotes95321912shotes
shute84520352shute_
shuted103913172shuted
shuts85622482shut_s
sites56045432s_ites
sixtes133612402sixtes
skates104219402skates
skites104418042skites
slates64934062slates
slues54527172slu_es
sluts54523982slut_s
smites83921922smites
smuts75415712smut_s
solutes73515262solutes
souses64229242souses
souter64225922souter
souters74422602souters
souths95216602souths
spates85028172spates
spites84127332spites
spues75025382spu_es
spumes1021314882spumes
stactes91914632stactes
states64337082states
statues74614902statues
statutes8368892statutes
stupes84116952stupes
sues46247652s_u_es
suets55126102s_uets
suites63727402suites
supes75628302s_upes
tastes64126422tastes
tates55444982ta_tes
taupes8212672taupes
tauted75317112tauted
tauten64311892tauten
tautens7317842tautens
tauter64318022tauter
tautest72612442tautest
tauts56125512taut_s
utes45930882__utes
wastes96224882wastes

Search took 6 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.673265514.1
2DLD Change Limit825511545.06016314.4
3Display Results1541540.0931655.9
 (SQL Overall)1786911545.82630671.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.