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

240 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
submits113975(None) 
submiss1138081submiss
submit10312671submit_
summits1137981summits
cubits103714032cub_its
qubits173710352qub_its
resubmits1342792resubmits
subedits1146712subedits
subito8410452sub_ito
sublets92616702sublets
sublimits1345562sublimits
sublots92410912sublots
subnets92512082subnets
subsets92813102subsets
subsist9311572subsist
subsists1037992subsists
subsite9412872subsite
subsites10312782subsites
subunits1046622subunits
suits55028052su__its
summit10311542summit_
admits9411413_admits
ambits103713413amb_its
audits72814113au_dits
baits76630583__baits
bits66148163__b_its
brits76433083__brits
bubbies103913513bubbies
commits133812383commits
cubbies133312883cubbies
cubics123810163cub_ics
cubist104214443cub_ist
cubists11359023cubists
cubit94122893cub_it_
cubiti10399083cub_iti
cubitus11346783cub_itus
cuboids1236723cuboids
cumbias13338963cumbias
cumins103314933cu_mins
cummins1358963cummins
debits94214503deb_its
demits94918073_demits
dubbins12358803dubbins
duits65021883du__its
dummies123012133dummies
emits75421473__emits
fumets114311813fu_mets
furmity1535183furmity
gambits12399723gambits
gummite1236133gummite
gummites1346173gummites
habits113014653hab_its
hermits12312143hermits
hobbits14317553hobbits
hubbies143211563hubbies
hubris11218973hubri_s
kumiss1235923ku_miss
limits82514143_limits
mummies103812843mummies
muskits13278563muskits
nubbins11268023nubbins
nubias8310093nub_ias
numbats1137673numbats
obits74617553_ob_its
omits75018263__omits
orbits84211443orb_its
outfits102210833outfits
outhits102213503outhits
outsits73215253outsits
outwits103110863outwits
permits11314003permits
pubis94616473pub_i_s
publics13207143publics
pulpits1137243pulpits
pundits10379293pundits
qubit164218993qub_it_
quits144122353qu__its
quoits15379683qu_oits
rabbits11299863rabbits
rebaits9312573rebaits
reemits9611303reemits
remits85622943_remits
resubmit1243573resubmit_
rubbies114114113rubbies
rubies84420343rub_ies
rubouts937983rubouts
rubrics1177093rubrics
rummies113212793rummies
sabbats1138633sabbats
sabins85521983sab_ins
sabirs85414633sab_irs
sabots8314703sab_ots
saimins9312113saimins
salmis8514273salmi_s
samite83020603s_amite
samites93118713s_amites
schuits1235823schuits
semis74623533s_emi_s
sennits73811283sennits
shits84731173s__hits
sits45050203s___its
skits94721863s__kits
slits56128853s__lits
smit65138413s__mit_
smite75224873s__mite
smites83921923s__mites
smith107818053s__mith
smiths114711023s__miths
smuts75415713s__muts
snits54124833s__nits
sobeit8315363sobeit_
soffits1335093soffits
somite84519373s_omite
somites94219123s_omites
spaits85017473s_paits
spirits94112623spirits
spits74429553s__pits
splits85416413s_plits
sprits85122533s_prits
stimies9316563stimies
straits74916323straits
stymies1239213stymies
suavity1336313suavity
subahs114512383sub_ahs
subas74724073sub__as
subbass1138033subbass
subbing123915583subbing
subbings13238483subbings
subcults1246933subcults
subcutes1238583subcutes
subcutis1246293subcutis
subdebs1236483subdebs
subducts13106093subducts
subdues1099893subdues
subedit1049403subedit_
suberins10315093suberins
subers85722643sub_ers
subfile122010503subfile
subfiles131710723subfiles
subfix1835073subfi_x
subfixes20207493subfixes
subgums1235893subgums
subitem1138553sub_item
subitems1245493sub_items
subjects19226533subjects
subjoins1745453subjoins
sublate9315363sublate
sublates10315003sublates
sublet82827243sublet_
sublime11310363sublime
sublimes12310033sublimes
sublimit1247513sublimit_
sublimity1644933sublimity
subline9316893subline
sublines10315783sublines
sublot82315523sublot_
submenu1148363submenu
submenus1245903submenus
submerse1237633submerse
submittal1343883submittal
submittals1452883submittals
submitted1445233submitted
submitter1345283submitter
submitters1444443submitters
subnet82520933subnet_
suborns939493suborns
subparts1246903subparts
subplots1255773subplots
subrents10310293subrents
subring104116263subring
subrings11229883subrings
subs66037123sub___s
subsects12267903subsects
subset83122583subset_
subside10410453subside
subsides11410823subsides
subsidy1345973subsidy
subsoils1076653subsoils
subtest9513963subtest
subtests1037533subtests
subtexts1744903subtexts
subtile91912623subtile
subtilty1345453subtilty
subtitle1046603subtitle
subtitles1156853subtitles
subunit948953subunit_
suburbs1136503suburbs
subverts1336973subverts
subvirus1344333subvirus
subways1536163subways
suets55126103su__ets
suints64617783su_ints
suit45649873su__it_
suite54829563su__ite
suites63727403su__ites
sulfids1137293sulfids
sulfite10310473sulfite
sulfites1139903sulfites
sulkies114315763sulkies
sullies74122233sullies
sumacs105512103su_macs
summas104313163su_mmas
summate113611663summate
summates122610493summates
summers113616503summers
summing122912383summing
summital1244703summital
summited13246413summited
summitry1543323summitry
summons1158003summons
sumoist9311613sumoist
sumoists1046733sumoists
sumos75720093su_m_os
sumps95023433su_m_ps
sums65837583su_m__s
sunbelts1044673sunbelts
sunkets113511283sunkets
sunlit61516103sunlit_
sunsets72911573sunsets
sunsuits845963sunsuits
surfeits1146223surfeits
surimis938843surimis
surmise9311083surmise
surmises10310643surmises
sushis9311183sushi_s
susliks1136443susliks
swamies123712063swamies
swamis114212293swami_s
symbiots1573623symbiots
tubaist938703tubaist
tubaists1055103tubaists
tubist83013163tub_ist
tubists9288323tubists
tummies113012033tummies
turbits969233turbits
unfits93910293_unfits
units54923433_u_nits
unwits9389893_unwits
vomits112610923_vomits
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 Limit1340272406.29621287.6
3Display Results2402400.0763157.9
 (SQL Overall)1786912406.77826363.4
 
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.