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

163 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
saute5502808(None) 
haute89521611haute
salute64418021salute
sate45556101sa_te
sauce75121651sauce
sauted74119601sauted
sautes63924911sautes
scute75520941scute
shute84520341shute
acute74720362acute
ante46538902_ante
astute6310762astute
ate37059242_a_te
auto47432082_auto
baste74829982baste
bate66552422ba_te
brute75321782brute
bute66739672_bute
carte75940422carte
caste75932362caste
cate66254592ca_te
cause75225352cause
chute104316462chute
cute66440452_cute
date56443322da_te
daube85015302daube
daut56443562daut_
dauted84114932dauted
dautie72914692dautie
dauts67822242dauts
elute54822572elute
fate75444282fa_te
fauve114712072fauve
flute86823752flute
gate55746572ga_te
gauge76117902gauge
gauze155712972gauze
glute66020902glute
haste85927862haste
hate78450172ha_te
haut75949732haut_
jute115327892_jute
late47560482la_te
latte55426302latte
lute46341012_lute
mate65154212ma_te
matte75626842matte
maut65448442maut_
mauts75927192mauts
mauve104013272mauve
mute65136872_mute
paste74932952paste
pate65350462pa_te
pause75021832pause
quate144521412quate
rate45458762ra_te
route55132072route
sabe66140572sa_be
sable74732162sable
sabre74821502sabre
sade55544472sa_de
sadhe94815132sadhe
sae38365182sa__e
safe75930952sa_fe
sage55044592sa_ge
saice75424052saice
saith85826552saith
saithe94713912saithe
sake85244962sa_ke
sale44959702sa_le
salt45758522salt_
salted74121202salted
salter64325082salter
saltie63422422saltie
salts55431882salts
salty85524382salty
saluted84511702saluted
saluter73512452saluter
salutes73716252salutes
salve85022132salve
same65245642sa_me
samite83020602samite
sane45954332sa_ne
santo56227282santo
sapote8314352sapote
saree55044662saree
sarge65531132sarge
sat36288482sa_t_
sated66238532sa_ted
satem76021452sa_tem
sates54949322sa_tes
sati45539322sa_ti
sau36356572sau__
sauced93913302sauced
saucer84314102saucer
sauces84919502sauces
sauch104918772sauch
saucy104615162saucy
sauger74316252sauger
saugh95318402saugh
saul45836522sau_l
sauls55128122sauls
sault55834962sault
saults65816172saults
sauna54117552sauna
saunter72913452saunter
saurel6511982saurel
saury84317222saury
sauteed8349612sauteed
savate9313782savate
save75741362sa_ve
scut65835542scut_
scuta75815752scuta
scutes85219192scutes
scuts74522522scuts
sente56432872sente
shote85526082shote
shut76137582shut_
shuted103913162shuted
shutes93518212shutes
shuts85622472shuts
site47052412s_ite
sixte126216582sixte
skate94721542skate
skite95120042skite
slate55438282slate
slue45332192slu_e
slut45040592slut_
sluts54523982sluts
smite75224872smite
smote75820272smote
smut66629782smut_
smuts75415712smuts
solute64016662solute
souse56530772souse
souter64225922souter
south85223572south
spate74731582spate
spite75430662spite
spue66025522spu_e
spume95817312spume
sputa74612962sputa
stacte82113912stacte
state56237332state
statue66015322statue
statute7419322statute
stupe75217752stupe
suave83519872suave
sue35651462s_u_e
suet46754822s_uet
suite54829562suite
supe65932762s_upe
sure45447412s_ure
taste55127232taste
tate44748602ta_te
taupe7314162taupe
taut47048962taut_
tauted75317112tauted
tauten64311892tauten
tauter64318022tauter
tauts56125512tauts
ute35335882__ute
waste86125052waste

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.0931921408.6
2DLD Change Limit538001631.58034050.6
3Display Results1631630.0433790.7
 (SQL Overall)1786911631.716104132.3
 
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.