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

233 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
subsites1031278(None) 
subsides11410821subsides
subsite9412871subsite_
subcutes1238582subcutes
subfiles131710722subfiles
subfixes20207492subfixes
subitem1138552sub_item
subitems1245492sub_items
sublates10315002sublates
sublimes12310032sublimes
sublines10315782sublines
submits1139752submit_s
subsales10310122subsales
subseres10312422subseres
subsets92813102subset_s
subside10410452subside_
subsided1257662subsided
subsider1138242subsider
subsiders1246052subsiders
subsidies1248422subsidies
subsisted1245782subsisted
subsister1145982subsister
subsisters1245022subsisters
subsists1037992subsists
substates111410332substates
subsumes1246922subsumes
subtitles1156852subtitles
suites63727402su__ites
sulfites1139902sulfites
websites1335182websites
albites9313203alb_ites
amosites10311233amosites
augites8312183au_gites
bites75641173__b_ites
blites84721213__blites
boites84322703__boites
bubbies103913513bubbi_es
burkites1436673burkites
bursitis1045033bursitis
busbies113011693busbi_es
busies85525263bu_si_es
coesites101313093coesites
cubbies133312883cubbi_es
cubists11359023cubist_s
cubits103714033cub_it_s
cubitus11346783cub_itus
cuisines1049373cuisines
cuprites1259023cuprites
curbsides1444483curbsides
curites93919863cu_rites
cursives1337103cursives
dumpsites1443763dumpsites
dunites8313593du_nites
dunnites947173dunnites
eucrites1049483eucrites
felsites1138073felsites
fubsier12367763fubsi_er
fubsiest13258413fubsi_est
gibbsites1442013gibbsites
gobshites1542933gobshites
gummites1346173gummites
gunites8313123gu_nites
gussies82813303gussi_es
hessites1138613hessites
hubbies143211563hubbi_es
hubrises1337103hubrises
hussies103213293hussi_es
inosites8312793inosites
jubiles16289373jub_iles
jussives1833843jussives
kunzites2143243kunzites
lucites9311863lu_cites
mullites10411643mullites
outsides92513233outsides
outsits73215253outsit_s
outsizes172311083outsizes
pulsates1048813pulsates
pussies93615693pussi_es
qubits173710353qub_it_s
qubytes2134383qub_ytes
resites74027793_resites
rubbies114114113rubbi_es
rubies84420343rub_i_es
sabines94318483sab_ines
samites93118713s_amites
sassies74719263sassi_es
seasides938743seasides
sensates8511143sensates
sienites8311913sienites
sissies73716603sissi_es
sites56045433___sites
skites104418043s__kites
smites83921923s__mites
somites94219123s_omites
sopites93817173s_opites
sorites73825243s_orites
soubises10107993soub_ises
spites84127333s__pites
sprites94220333s_prites
stibnites1144043stibnites
stipites1039653stipites
stylites11168693stylites
suasions838783suasions
suasive1037853suasive_
suavities1248413suavities
subbases1239063subbases
subbings13238483subbings
subcastes1387493subcastes
subcodes1338143subcodes
subcutis1246293subcutis
subduces1397263subduces
subdues1099893sub_dues
subedited1345543subedited
subedits1146713subedit_s
suberises11813453suberises
suberizes20811833suberizes
subfile122010503subfile_
subidea1037533sub_idea
subideas1146443sub_ideas
subito8410453sub_it_o
sublate9315363sublate_
sublated11311503sublated
sublets92616703sublet_s
sublimates1447173sublimates
sublime11310363sublime_
sublimed1337213sublimed
sublimer1237613sublimer
sublimers1345773sublimers
sublimest1346713sublimest
subline9316893subline_
sublots92410913sublot_s
submiss1138083submi_ss
submit10312673submit__
submitted1445233submitted
submitter1345283submitter
submitters1444443submitters
subnets92512083subnet_s
subniches1665153subniches
suboscines1444963suboscines
suboxides1944993suboxides
subraces12313033subraces
subrings11229883subrings
subrules1039723subrules
subsale9310543subsale_
subscales1347343subscales
subscribes1644873subscribes
subsea82610193subs__ea
subsects12267903subsects
subsense1046963subsense
subsenses1147473subsenses
subsere9311443subsere_
subseries11312933subseries
subserves1447183subserves
subset83122583subs__et
subsidise1245293subsidise
subsidises1345123subsidises
subsidizes2245083subsidizes
subsidy1345973subsi_dy
subsist9311573subsi_st
subsistent12105223subsistent
subskills1543773subskills
subsoiled1245453subsoiled
subsoiler1145323subsoiler
subsoilers1244063subsoilers
subsoils1076653subsoils
subspaces1545673subspaces
substages12127353substages
substate101711093substate_
substitutes1354353substitutes
substrates12168553substrates
subsume1146713subsume_
subsumed1344943subsumed
subsystem1652393subsystem
subsystems1751833subsystems
subtest9513963sub__test
subtile91912623subtile_
subtiler10208573subtiler
subtilest1148813subtilest
subtilties1246113subtilties
subtitle1046603subtitle
subtitled1244713subtitled
subtones10311383subtones
subtribes1346233subtribes
subtypes1544553subtypes
subunits1046623subunit_s
subvenes1339633subvenes
subvirus1344333subvirus
subwriter1445623subwriter
subwriters1544413subwriters
subzones1947223subzones
sudses74114503suds__es
sudsier868783sudsi_er
sudsiest939623sudsi_est
suffices16208183suffices
suffixes21196353suffixes
suicides1139083suicides
suite54829563su__ite_
suited74019423su__ited
suiter64121813su__iter
suiters73618883su__iters
suits55028053su__it_s
sulfates11310793sulfates
sulfides1238053sulfides
sulfite10310473sulfite_
sulkies114315763sulki_es
sullies74122233sulli_es
sulphites1445683sulphites
summates122610493summates
summited13246413summited
summits1137983summit_s
sunrises8310693sunrises
sunsets72911573sunset_s
sunshines1246583sunshines
sunsuits845963sunsuit_s
supines94216383su_pines
sureties8316583sureties
surmises10310643surmises
surtitles945633surtitles
survives1436333survives
suspires1038203suspires
susses64221053su_s_ses
sybarites1465933sybarites
syenites1138943syenites
sylvites14225843sylvites
tubists9288323tubist_s
turgites937783turgites
tussises835433tussises
unites65024853_u_nites
upsides10319633_upsides
upsizes18297163_upsizes
website1235323website_
wussies103411083wussi_es
zoisites1744973zoisites

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622337.40619735.6
3Display Results2332330.1062198.1
 (SQL Overall)1786912337.91822567.7
 
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.