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

182 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
subbase113932(None) 
subbases1239061subbases
subbass1138031subbass
surbase939791surbase
bubbas94110702bubbas_
subas74724072su_bas_
subbasin1245392subbasin
subbasses1345222subbasses
subcaste1287852subcaste
subcause1265822subcause
sublate9315362sublate
sublease1038382sublease
subphase1555602subphase
subrace11313002subrace
subsale9310542subsale
subtask1335712subtask
sucrase9310342sucrase
surbased1136612surbased
surbases10310002surbases
abase76023483__abase
abbas95918643_abbas_
aubade939223au_bade
base64847023___base
blase75524233__blase
bubale104014623bu_bale
bubba84311803bubba__
bubbies103913513bubbies
bubble94016593bubb_le
bubbles104315963bubbles
bugbane1255863bugbane
cabbage1446983cabbage
cubage1178273cu_bage
cubbies133312883cubbies
cubbish1635803cubbish
debase94014473_debase
diabase1037113diabase
euclase938933euclase
gibbose1244083gibbose
guanase836213guanase
hubbies143211563hubbies
jubas144614223ju_bas_
jubbah2034353jubba_h
jubbahs2143623jubbahs
kurbash1643803kurbash
mutase82811993mu_tase
nubble103813713nubb_le
nubbles113412433nubbles
nubias8310093nubias_
nutcase975763nutcase
outbake13310773outbake
rubace10310173ru_bace
rubasse934903rubasse
rubbies114114113rubbies
rubbish1436303rubbish
rubble104315673rubb_le
rubbles113715113rubbles
rumbas102512013rumbas_
sabbat10314713sabba_t
sabbath1445393sabbath
sabbats1138633sabbats
sabras85116363sabras_
sambas104219263sambas_
scubas103710223scubas_
sibbs96211903sibb_s_
sobas74424253s_obas_
sorbate9311733sorbate
sorbose938983sorbose
soubise9118793soubise
stubble1136843stubb_le
stubbles1236843stubbles
suable83920553suab_le
suave83519873su__ave
suba64926603su_ba__
subah106015213su_ba_h
subahs114512383su_bahs
subarea939403su_barea
subbasins1344763subbasins
subbed114116673subb_ed
subbing123915583subbing
subbreed1345873subbreed
subcastes1387493subcastes
subcauses1346213subcauses
subchaser1644313subchaser
subclass1246623subclass
subclause1353843subclause
subcode1237163subcode
subduce12106983subduce
subdue9128493su_bdue
subdues1099893subdues
suberise10813933suberise
suberose10109693suberose
subers85722643subers_
subfile122010503subfile
subframe1546333subframe
subfusc1444333subfusc
subgrade1246053subgrade
sublated11311503sublated
sublates10315003sublates
subleased1246123subleased
subleases1148653subleases
sublime11310363sublime
subline9316893subline
submerse1237633submerse
submiss1138083submiss
subnasal1044183subnasal
subovate1347333subovate
subpanel1246073subpanel
subpar1048663subpa_r
subpart11311123subpart
subphases1645753subphases
subraces12313033subraces
subrule939643subrule
subs66037123su_b_s_
subsales10310123subsales
subscale1247603subscale
subsea82610193su_b_sea
subsense1046963subsense
subsere9311443subsere
subset83122583su_b_set
subside10410453subside
subsist9311573subsist
subsite9412873subsite
subspace1445683subspace
substage11117183substage
substate101711093substate
subsume1146713subsume
subtasks1444493subtasks
subtaxa1644483subtaxa
subtest9513963subtest
subtile91912623subtile
subtle82113433su_btle
subtone9310343subtone
subtype1444203subtype
subulate10312743subulate
subvene1238493subvene
subway1447073subwa_y
subwayed1753723subwayed
subways1536163subways
subzone1846993subzone
sucrases10310253sucrases
sucrose939303sucrose
suffuse1335443suffuse
suitcase1043893suitcase
sulcate9314423sulcate
sulfas9311563sulfas_
sulfate10311653sulfate
sullage859913sullage
summae103911013summa_e
summas104313163summas_
summate113611663summate
sunback1548153sunback
sunbaked1545533sunbaked
sunbath1236423sunbath
sunbathe1344033sunbathe
sundae7312873sunda_e
sundaes8313093sundaes
sunfast1038503sunfast
sunnas63914563sunnas_
sunrise7310813sunrise
sunwise1036433sunwise
suppose1137973suppose
suras55336333su_ras_
surcease1086883surcease
surface1238653surface
surmise9311083surmise
surname937603surname
surpass938283surpass
surras65919533surras_
sutras64818593sutras_
suttas63813793suttas_
tubae74716643tu_ba_e
tubas75119583tu_bas_
tubate82813173tu_bate
tubbable1134683tubbable
ukase9428493_u_kase
unbale83616403_unbale
unbased103513483_unbased
uncase83817433_uncase
unease63816643_unease
urase54624693_u_rase
urbane82211383_urbane
urease64516993_urease

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 Limit1340271826.45320769.7
3Display Results1821820.0802275.0
 (SQL Overall)1786911826.93925751.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.