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

220 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
summate11361166(None) 
summae103911011summa_e
summated13298831summated
summates122610491summates
gemmate12418382gemmate
gummata1244612gummata
gummite1236132gummite
humate113214442hu_mate
mammate104411272mammate
rummage1234582rummage
sigmate10710142sigmate
soulmate1047182soulmate
squamate1945782squamate
stomate9313122stomate
sublate9315362sublate
sulcate9314422sulcate
sulfate10311652sulfate
summa94713312summa__
summable1436902summable
summand1236262summand
summary14297352summary
summas104313162summa_s
summative1646202summative
summit10311542summit_
summited13246412summited
summits1137982summits
agemate101210583agemate
animate91617213animate
aurate64426473au_rate
aureate72515283aureate
automate10411943automate
bedmate1239433bedmate
bromate11313553bromate
bullate93415073bullate
bummalo1353793bummalo
bunkmate1643963bunkmate
bursate94111203bursate
climate11312833climate
comate104124843_comate
commata1338483commata
commute134310443commute
consummate1654263consummate
cremate113816183cremate
cumulate123110223cumulate
cuneate9311723cuneate
curate85226243cu_rate
curtate9312643curtate
cuspate1138233cuspate
emulate9314123emulate
estimate10912003estimate
fermate122813003fermate
formate123115093formate
fumarate1345683fumarate
fumette1245523fumette
fumigate1446153fumigate
furcate12310453furcate
gemmae11507793gemma_e
gemmated14336293gemmated
gemmates13307673gemmates
gumma105313103gumma__
gummas114810513gumma_s
gummites1346173gummites
gummose1235333gummose
guttate8328903guttate
hamate113319833_hamate
humane112812173hu_mane
humates122813193hu_mates
hummable1744583hummable
imamate1138103imamate
immane1038883_immane
inmate82917363_inmate
jugate14379463ju_gate
lemmata1144673lemmata
limbate1139213limbate
lunate6316043lu_nate
luxate1338083lu_xate
mammae94613213mamma_e
mammati10398373mammati
mate65154223___mate
mismate111415353mismate
muriate9313363muriate
mutate83017483mu_tate
numbat10312083numbat_
numbats1137673numbats
numerate101610393numerate
nummary14314653nummary
nutate63017373nu_tate
ostomate1049573ostomate
outate62923403ou_tate
outdate83016423outdate
outrate72323183outrate
palmate113215233palmate
plumate1149803plumate
primate111516283primate
psammite1442983psammite
pulsate9510233pulsate
pupate104213123pu_pate
quate144521413qu__ate
quinate16511573quinate
ramate83921683_ramate
remate84428683_remate
roommate1244863roommate
rugate75813813ru_gate
ruinate7312833ruinate
ruminate10511473ruminate
rummaged1443273rummaged
rummager1343593rummager
rummages1344933rummages
saccate111311763saccate
samite83020603s_amite
sate45556103s___ate
satiate7315403satiate
savate9313783s_avate
schmatte1544473schmatte
scrummage1641873scrummage
scutate9310323scutate
seatmate1048573seatmate
sedate73019813s_edate
semimat11412903semimat_
semimatt1258303semimatt
semimatte1354733semimatte
semimute1245513semimute
senate63725173s_enate
sensate7311893sensate
septate9511873septate
seriate73722473seriate
serrate73017543serrate
sfumato1253683sfumato
shipmate1546153shipmate
simulate10311133simulate
sinuate7412163sinuate
situate7410783situate
skate94721553s__kate
slate55438283s__late
smaze165012933s__maze
smite75224873s__mite
smote75820283s__mote
solate64526073s_olate
solvate102710213solvate
somata8312383s_omata
somite84519373s_omite
sorbate9311733sorbate
soulmates1147073soulmates
spate74731583s__pate
spicate113214193spicate
spinate93114813spinate
squamae1845723squama_e
squamates2045593squamates
state56237333s__tate
stemmata1244213stemmata
stomata938533stomata
stomates10313343stomates
striate74218953striate
stumpage1343303stumpage
stylate10179773stylate
suave83519873su__ave
subbase1139323subbase
subcaste1287853subcaste
sublated11311503sublated
sublates10315003sublates
sublimate1347433sublimate
submit10312673submit_
submits1139753submits
subovate1347333subovate
subrace11313003subrace
subsale9310543subsale
subsite9412873subsite
substate101711093substate
subulate10312743subulate
sucrase9310343sucrase
sufflate1456183sufflate
suite54829563su__ite
sulcated11310373sulcated
sulfated1238833sulfated
sulfates11310793sulfates
sulfite10310473sulfite
sullage859913sullage
sulphate1346643sulphate
sumac99514883su_ma_c
sumach135310113su_mach
sumacs105512103su_macs
summands1344713summands
summaries13118183summaries
summarise13115733summarise
summarize22105653summarize
summating1437943summating
summation1347803summation
summed114014043summ_ed
summer104017713summ_er
summered1338143summered
summers113616503summers
summery14329413summery
summing122912383summing
summital1244703summital
summiteer1343003summiteer
summitry1543323summitry
summon1037623summ_on
summoned1345723summoned
summoner1245533summoner
summons1158003summons
sumpter1138873su_mpter
sunbath1236423sunbath
sunbathe1344033sunbathe
sundae7312873sunda_e
supinate10310313supinate
surbase939793surbase
surface1238653surface
suricate10312613suricate
surmise9311083surmise
surname937603surname
teammate1245613teammate
tubate82813173tu_bate
unmade92911063_unmade
unmake122811213_unmake
unmated103317023_unmated
update93810293_update
uprate83916543_uprate
urate55432163_u_rate
vulgate11388433vulgate
vulvate13388323vulvate

Search took 8 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.403443402.0
2DLD Change Limit1340272207.08018930.4
3Display Results2202200.0762894.7
 (SQL Overall)1786912207.55923639.5
 
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.