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

161 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
submiss113808(None) 
submits1139751submits
kumiss1235922ku_miss
subbass1138032subbass
submit10312672submi_t
subsist9311572subsist
subsists1037992subsists
summits1137982summits
surmise9311082surmise
surmises10310642surmises
amiss75823073__amiss
bliss75616913__bliss
briss75824273__briss
bubbies103913513bubbies
cubbies133312883cubbies
cubbish1635803cubbish
cubics123810163cub_ics
cubism12348703cub_ism
cubisms13306883cub_isms
cubist104214443cub_ist
cubists11359023cub_ists
cubits103714033cub_its
cuboids1236723cuboids
cumbias13338963cumbias
cumins103314933cu_mins
cummins1358963cummins
dismiss1038153dismiss
dubbins12358803dubbins
dummies123012133dummies
hubbies143211563hubbies
hubris11218973hubri_s
hubrises1337103hubrises
koumiss1344313koumiss
miss65339423___miss
mummies103812843mummies
nubbins11268023nubbins
nubias8310093nub_ias
outkiss1137783outkiss
premiss113513813premiss
pubis94616473pub_i_s
publics13207143publics
publish1447913publish
qubits173710353qub_its
remiss84216353_remiss
resubmits1342793resubmits
rubbies114114113rubbies
rubbish1436303rubbish
rubies84420343rub_ies
rubrics1177093rubrics
rummies113212793rummies
sabins85521983sab_ins
sabirs85414633sab_irs
saimins9312113saimins
salmis8514273salmi_s
semis74623533s_emi_s
semises93916553s_emises
slumism1136513slumism
slumisms1244723slumisms
snubness1044373snubness
soubise9118793soub_ise
soubises10107993soub_ises
speiss84311643s_peiss
stimies9316563stimies
stymies1239213stymies
subahs114512383sub_ahs
subas74724073sub__as
subbase1139323subbase
subbases1239063subbases
subbing123915583subbing
subbings13238483subbings
subclass1246623subclass
subdebs1236483subdebs
subdues1099893subdues
subedits1146713subedits
suberins10315093suberins
suberise10813933suberise
suberises11813453suberises
subers85722643sub_ers
subfile122010503subfile
subfiles131710723subfiles
subfix1835073subfi_x
subfixes20207493subfixes
subfusc1444333subfusc
subfuscs1543753subfuscs
subgums1235893subgums
subito8410453sub_ito
subjoins1745453subjoins
sublets92616703sublets
sublime11310363sublime
sublimes12310033sublimes
sublimits1345563sublimits
subline9316893subline
sublines10315783sublines
sublots92410913sublots
submenu1148363submenu
submenus1245903submenus
submerse1237633submerse
submerses1348003submerses
submission1453743submission
submissive1762833submissive
subnets92512083subnets
suborns939493suborns
subring104116263subring
subrings11229883subrings
subs66037123sub___s
subsets92813103subsets
subside10410453subside
subsides11410823subsides
subsidy1345973subsidy
subsite9412873subsite
subsites10312783subsites
subsoils1076653subsoils
subtask1335713subtask
subtasks1444493subtasks
subtest9513963subtest
subtests1037533subtests
subtile91912623subtile
subunits1046623subunits
suburbs1136503suburbs
subvirus1344333subvirus
subways1536163subways
success1146403success
succuss1134993succuss
suits55028053su__its
sulfids1137293sulfids
sulkies114315763sulkies
sullies74122233sullies
sumacs105512103su_macs
sumless92611123sumless
summas104313163su_mmas
summers113616503summers
summing122912383summing
summit10311543summi_t
summons1158003summons
sumoist9311613sumoist
sumoists1046733sumoists
sumos75720093su_m_os
sumps95023433su_m_ps
sums65837583su_m__s
sunfish1338883sunfish
sunless73013693sunless
sunrise7310813sunrise
sunrises8310693sunrises
sunwise1036433sunwise
surimis938843surimis
surmised1136863surmised
surmiser1036763surmiser
surmisers1145203surmisers
surpass938283surpass
sushis9311183sushi_s
susliks1136443susliks
suss45229303su___ss
swamies123712063swamies
swamis114212293swami_s
swiss86712903s__wiss
tubaist938703tubaist
tubaists1055103tubaists
tubist83013163tub_ist
tubists9288323tub_ists
tummies113012033tummies
yummies14359533yummies

Search took 7 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.406440125.6
2DLD Change Limit1340271615.90622693.4
3Display Results1611610.0602683.3
 (SQL Overall)1786911616.37228043.2
 
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.