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

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

235 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
saccate11131176(None) 
baccate131011261baccate
saccade12107031saccade
acuate8315632_acuate
baccae12119702bacca_e
baccated15148372baccated
falcate12311612falcate
lactate9312692lactate
saccades13137242saccades
sacculate1349022sacculate
saccule1136742saccule
satiate7315402satiate
savate9313782sa_vate
soccage1236282soccage
spicate113214192spicate
staccati1244672staccati
staccato1244062staccato
sulcate9314422sulcate
toccate1138772toccate
vacate11314552va_cate
abate76627843_a_bate
ablate82219213_ablate
accede1138293_accede
accrete1137843_accrete
accrue1035823_accrue
accurate12410663_accurate
accuse103411033_accuse
acerate92818913_acerate
acetate92514753_acetate
actuate9311443_actuate
acute74720363_a_cute
acylate12310533_acylate
adnate72913483_adnate
aerate64830553_aerate
agate66525143_a_gate
agnate73314873_agnate
alate55340323_a_late
alcade91111513_alcade
ansate64517863_ansate
arcade91013643_arcade
arcane81216743_arcane
arcuate9311963arcuate
ashcake1663373ashcake
aurate64426473_aurate
aviate9315203_aviate
bacca111012183bacca__
baccara1347143baccara
bacchante1844653bacchante
backdate1748223backdate
barbate11314543barbate
calceate1239863calceate
calcite11413783calcite
calycate1537893calycate
carate84734003ca_rate
carcase11312733carcase
cascade12118603cascade
caseate9314783caseate
cate66254593___cate
caudate10311353caudate
crate76537403__crate
dacite91115883da_cite
daycare1355093daycare
desiccate1445923desiccate
dictate10311663dictate
educate10310213educate
emaciate1248753emaciate
escalate1039323escalate
evacuate13217303evacuate
exsiccate2043143exsiccate
facade1238803fa_cade
facete115014833fa_cete
faciae112913413facia_e
falcated1438473falcated
fasciate1347563fasciate
furcate12310453furcate
galeate83916783galeate
gallate83417123gallate
glaciate1168073glaciate
hamate113319823ha_mate
hastate10313913hastate
jaculate172311783jaculate
karate105320923ka_rate
labiate91313573labiate
lacerate102214703lacerate
lactase937953lactase
lactated1138863lactated
lactates10311223lactates
lacunate10128963lacunate
lanate6421263la_nate
leachate1347443leachate
locate83919843_locate
macchie1647193macchie
macerate122314073macerate
machete14310883machete
macrame1338713macrame
maculate122815623maculate
magnate10512703magnate
malate84624553ma_late
maleate94117543maleate
mammate104411273mammate
mandate10315573mandate
marcato1139743marcato
narrate7313493narrate
nictate9310223nictate
oatcake1345363oatcake
package16128013package
palate84226783pa_late
paleate94120003paleate
palmate113215233palmate
palpate113213923palpate
pancake1536673pancake
pectate112214693pectate
piccata1345703piccata
picrate112014143picrate
placate11312433placate
plicate11314513plicate
racemate1239063racemate
radiate83416313radiate
radicate11412873radicate
ramate83921683ra_mate
recrate92621643recrate
sabbat10314713sabbat_
sabbath1445393sabbath
sabbats1138633sabbats
sacaton938993sa_caton
sacbut10811943sacbut_
sacbuts1166473sacbuts
saccadic1244173saccadic
sacculated1546623sacculated
saccules1237033saccules
sacculi1145043sacculi
sachet114725773sachet_
sacheted14127833sacheted
sachets123914103sachets
saclike131210123saclike
sacque17107113sa_cque
sacra74516993sacra__
sacral83414413sacra_l
sacrals93311793sacrals
saice75424053saic__e
salivate11310013salivate
salpae84614273salpa_e
salute64418023sa_lute
salvage1138193salvage
samite83020603sa_mite
sancta839833sanc_ta
sanitate8612043sanitate
sapote8314353sa_pote
sarape84817573sa_rape
sarcasm1136693sarcasm
sate45556103s___ate
satiated9311603satiated
satiates8314633satiates
saturate8312813saturate
sauce75121653sauc__e
sausage847193sausage
saute55028083sa__ute
savage10410173sa_vage
savates10312953sa_vates
scalade10359263scalade
scalage103110533scalage
scalare93311833scalare
scale74629143s__cale
scape96921843s__cape
scare75334463s__care
scat65848373s__cat_
scathe114414993s__cathe
scats75930603s__cats
scatt76030093s__catt
scrape105917573s_crape
scutate9310323scutate
scute75520943s__cute
seascape1245173seascape
seatmate1048573seatmate
secrete9311073secrete
sedate73019803s_edate
senate63725143s_enate
sensate7311883sensate
septate9511873septate
seriate73722473seriate
serrate73017533serrate
siccan1037593sicca_n
siccative1645103siccative
sigmate10710123sigmate
silicate10312623silicate
sinuate7412153sinuate
situate7410773situate
skate94721543s__kate
slate55438283s__late
socage91012123s_ocage
soccages1336383soccages
solate64526073s_olate
solvate102710213solvate
sonicate10310933sonicate
sorbate9311733sorbate
spate74731583s__pate
speciate12209583speciate
spectate12248833spectate
spicae104313703spica_e
spicated13309903spicated
spiccato1463183spiccato
spinate93114813spinate
staccatos1343723staccatos
stacte82113913stac_te
stagnate947243stagnate
state56237333s__tate
stoccata1243563stoccata
stomate9313123stomate
striate74218953striate
stylate10179773stylate
subcaste1287853subcaste
sublate9315363sublate
succah1336643succa_h
succahs1435323succahs
succinate1346683succinate
succoth1445093succoth
sucrase9310343sucrase
sulcated11310373sulcated
sulfate10311653sulfate
summate113611663summate
suricate10312613suricate
tannate71813523tannate
thecate123210023thecate
toccata1144943toccata
tractate10411003tractate
uncrate9415953uncrate
vacated1349353va_cated
vacates12312833va_cates
vaccinate1646833vaccinate
vaccine1437323vaccine
vallate103016563vallate
valuate102512733valuate
valvate133710813valvate
variate101316433variate
zincate1838533zincate

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272358.00016753.4
3Display Results2352350.0932526.9
 (SQL Overall)1786912358.24921662.1
 
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.