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

154 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
subbases123906(None) 
subbase1139321subbase_
subbass1138031subbas_s
subbasses1345221subbasses
surbases10310001surbases
subbasin1245392subbasin
subbasins1344762subbasins
subcastes1387492subcastes
subcauses1346212subcauses
sublates10315002sublates
subleases1148652subleases
subphases1645752subphases
subraces12313032subraces
subsales10310122subsales
subtasks1444492subtasks
sucrases10310252sucrases
surbase939792surbase_
surbased1136612surbased
abases85720773__abases
anabases1038083anabases
aubades1038753au_bades
baases85218013__baases
bases75644353___bases
biases84618433__biases
bubales113513343bu_bales
bubbas94110703bubba__s
bubbies103913513bubb_ies
bubbles104315963bubb_les
bubblies1166773bubblies
bugbanes1345153bugbanes
cabbages1537203cabbages
cubages1237923cu_bages
cubbies133312883cubb_ies
cutlases1038033cutlases
debases103814133_debases
diabases1137223diabases
euclases1039223euclases
guanases936233guanases
hubbies143211563hubb_ies
hubrises1337103hubrises
jubbahs2143623jubba_hs
judases1534443ju_dases
kurbashes1883523kurbashes
mutases92012043mu_tases
nubbles113412433nubb_les
nutcases1085793nutcases
outbakes1439993outbakes
rubaces1139313ru_baces
rubasse934903ru_basse
rubasses1035493rubasses
rubbies114114113rubb_ies
rubbishes1644303rubbishes
rubbles113715113rubb_les
sabbaths1543973sabbaths
sabbats1138633sabba_ts
sorbates10311103sorbates
sorboses1038523sorboses
soubises10107993soubises
stases64225563s__tases
stubbles1236843stubb_les
subahs114512383su_ba_hs
subarea939403su_barea
subareas1038623su_bareas
subas74724073su_ba__s
subbed114116673subb__ed
subbings13238483subbings
subbreed1345873subbreed
subbreeds1443573subbreeds
subcaste1287853subcaste
subcause1265823subcause_
subchaser1644313subchaser
subchasers1743283subchasers
subclass1246623subclas_s
subclasses1444743subclasses
subclauses1453883subclauses
subcodes1338143subcodes
subcutes1238583subcutes
subduces1397263subduces
subdues1099893su_bdues
suberises11813453suberises
subfiles131710723subfiles
subfixes20207493subfixes
subframes1645853subframes
subfuscs1543753subfuscs
subgrades1346313subgrades
sublate9315363sublate_
sublated11311503sublated
sublease1038383sublease_
subleased1246123subleased
sublimes12310033sublimes
sublines10315783sublines
submerses1348003submerses
submiss1138083submis_s
subnasal1044183subnasal
subpanel1246073subpanel
subpanels1344393subpanels
subparts1246903subparts
subphase1555603subphase_
subrace11313003subrace_
subrules1039723subrules
subsale9310543subsale_
subscales1347343subscales
subsea82610193su_b_sea
subsenses1147473subsenses
subseres10312423subseres
subset83122583su_b_set
subsets92813103su_b_sets
subsides11410823subsides
subsists1037993subsists
subsites10312783subsites
subspaces1545673subspaces
substages12127353substages
substates111410333substates
subsumes1246923subsumes
subtask1335713subtas_k
subtests1037533subtests
subtones10311383subtones
subtypes1544553subtypes
subvenes1339633subvenes
subwayed1753723subwayed
subways1536163subwa_ys
subzones1947223subzones
sucrase9310343sucrase_
sucroses1039933sucroses
sudses74114503su__dses
suffuses1435833suffuses
suitcases1144453suitcases
sulfates11310793sulfates
sullages939973sullages
summates122610493summates
sunbaked1545533sunbaked
sunbathes1444113sunbathes
sunbaths1344383sunbaths
sundaes8313093sunda_es
sunrises8310693sunrises
supposes1238203supposes
surceases1157473surceases
surfaces1338673surfaces
surmises10310643surmises
surnames1037273surnames
surpass938283surpas_s
surpasses1145533surpasses
surtaxes1536513surtaxes
susses64221053su__sses
syngases1245073syngases
tabbises12236523tabbises
ukases10358063_u_kases
unbales92914863_unbales
unbased103513483_unbased
uncases93516553_uncases
uneases73316263_uneases
upases84112903_u_pases
urases63723563_u_rases
ureases74416723_ureases

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.420425454.8
2DLD Change Limit1461621546.61022112.3
3Display Results1541540.0632444.4
 (SQL Overall)1786911547.09325192.6
 
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.