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

250 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
summit1031154(None) 
submit10312671submit
summits1137981summits
commit124016702commit
cummin1288782cummin
dammit11311132dammit
gummite1236132gummite
smit65138412s__mit
submits1139752submits
suit45649872su__it
summa94713312summ_a
summae103911012summae
summas104313162summas
summate113611662summate
summed114014042summed
summer104017712summer
summing122912382summing
summital1244702summital
summited13246412summited
summitry1543322summitry
summon1037622summon
sumoist9311612sumoist
sunlit61516102sunlit
admit8319493_admit
ambit94223713_ambit
armpit10811093armpit
audit62527883au_dit
bumkin14308083bumkin
bummed134211723bummed
bummer124014103bummer
bummest13298623bummest
bumming143410783bumming
cammie124615293cammie
comfit133112423comfit
commie124215523commie
commits133812383commits
commix19407763commix
commixt20357623commixt
crummie1336153crummie
cubit94122893cu_bit
cumbia12379893cumbia
cumin94616973cu_min
cummer124414593cummer
cummins1358963cummins
demit84832303_demit
dimwit1237953dimwit
duit56241583du__it
dummied13346723dummied
dummies123012133dummies
dummy134712783dumm_y
duomi8310133duomi_
emit65438423__emit
emmet94221383_emmet
fumet105630223fu_met
furmity1535183furmity
gambit114714213gambit
gimmie11298183gimmie
grummet12298873grummet
gumma105313103gumm_a
gummas114810513gummas
gummata1244613gummata
gummed123811663gummed
gummer114615453gummer
gummier12349473gummier
gummiest13269023gummiest
gumming133810193gumming
gummites1346173gummites
gummy135413653gumm_y
hermit11519443hermit
humic124113243hu_mic
humid114213763hu_mid
hummed144812673hummed
hummer133615273hummer
humming153310673humming
hummus1336243hummus
immix1635033_immix
jimmie17376473jimmie
kummel14266173kummel
limit73126343_limit
lummox1733053lummox
mammet94319253mammet
mammie94313783mammie
mumm75718863mumm__
mummed104411553mummed
mummer93614543mummer
mummied11327103mummied
mummies103812843mummies
mummify1643333mummify
mumming114010023mumming
mumms85513153mumm_s
mummy114913623mumm_y
muskit122813253muskit
numbat10312083numbat
omit65337373__omit
outfit93014953outfit
outhit92818473outhit
outsit63620893outsit
outwit93014593outwit
permit10321683permit
plummet13278353plummet
pommie123710503pommie
presummit1553133presummit
psammite1442983psammite
pulpit10310933pulpit
pummel12278043pummel
pundit92914183pundit
qubit164218993qu_bit
quit136136513qu__it
quoit143819863qu_oit
reemit8717223reemit
remit75737223_remit
resubmit1243573resubmit
rummer104715483rummer
rummest11279833rummest
rummier11309563rummier
rummies113212793rummies
rummiest12299353rummiest
rummy124212413rumm_y
saimin8313663saimin
salmi7815863salmi_
salmis8514273salmis
samite83020603s_amite
samlet84126563samlet
schuit1139563schuit
scummed14347913scummed
scummer13398753scummer
scummier1445083scummier
scummiest1535213scummiest
scummily1743303scummily
scumming15256793scumming
scummy15265223scumm_y
sememic1336503sememic
semi65127223s_emi_
semifit1249973semifit
semimat11412903semimat
semis74623533s_emis
sennit63117923sennit
shit76745943s__hit
simlin8311733simlin
simmer104115353simmer
sit35877753s___it
skit85437533s__kit
skylit1338283skylit
slit46250103s__lit
slummed12359273slummed
slummer113711203slummer
slummier1235473slummier
slummiest1335663slummiest
slumming13278383slumming
slummy13325863slumm_y
smalt74729333s_malt
smart75834093s_mart
smelt74726783s_melt
smite75224873s__mite
smith107818053s__mith
smolt74824163s_molt
smut66629783s__mut
snit46342473s__nit
sobeit8315363sobeit
soffit1237883soffit
somite84519373s_omite
spait75631603s_pait
spirit83519923spirit
spit65545083s__pit
split75729013s_plit
sprit76736403s_prit
strait64025893strait
stummed12348553stummed
stumming13347673stumming
stymie1137623stymie
suavity1336313suavity
subedit1049403subedit
subfix1835073subfix
subito8410453su_bito
sublet82827243sublet
sublimit1247513sublimit
sublot82315523sublot
submiss1138083submiss
subnet82520933subnet
subset83122583subset
subsist9311573subsist
subsite9412873subsite
subunit948953subunit
suet46754823su__et
suffix1935233suffix
suint55638183su_int
suite54829563su__ite
suits55028053su__its
sukkot936643sukkot
sulci7615053sulci_
sulfid1039063sulfid
sulfite10310473sulfite
sum56346013su_m__
sumac99514883su_mac
sumach135310113sumach
sumacs105512103sumacs
summand1236263summand
summarist13116763summarist
summary14297353summary
summated13298833summated
summates122610493summates
summers113616503summers
summery14329413summery
summiteer1343003summiteer
summiting1445793summiting
summons1158003summons
sumo67326313su_m_o
sumoists1046733sumoists
sumos75720093su_mos
sump86331533su_m_p
sumps95023433su_mps
sums65837583su_m_s
sunket103721363sunket
sunset63723633sunset
sunsuit748693sunsuit
surest65026763surest
surfeit10310343surfeit
surimi839103surimi
surimis938843surimis
surmise9311083surmise
sushi8310493sushi_
sushis9311183sushis
suslik1036373suslik
swami105614523swami_
swamis114212293swamis
symbiot1465273symbiot
tammie104212693tammie
tomtit8413853tomtit
tumid84114023tu_mid
tummies113012033tummies
tummy124711993tumm_y
tumult839703tumult
turbit8715113turbit
umami939883_umami_
umamis1038273_umamis
umm711921263_umm__
unfit84518563_unfit
unit45140073_u_nit
unlit55025463_unlit
unmet74426393_unmet
unmix14388973_unmix
unmixt15378703_unmixt
unwit84417523_unwit
uplit76020803_uplit
vomit102622573_vomit
wimmin1336153wimmin
yummier14306843yummier
yummies14359533yummies
yummiest15256723yummiest
yummy15429153yumm_y

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 Filter1786911127160.376475242.0
2DLD Change Limit1127162505.23321539.5
3Display Results2502500.0763289.5
 (SQL Overall)1786912505.68531432.0
 
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.