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

168 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
subbass113803(None) 
subbase1139321subbase
subbases1239061subbases
bubbas94110702bubba_s
jubbahs2143622jubbahs
sabbats1138632sabbats
subahs114512382su_bahs
subas74724072su_ba_s
subbasin1245392subbasin
subbasins1344762subbasins
subbasses1345222subbasses
subclass1246622subclass
submiss1138082submiss
subtask1335712subtask
subtasks1444492subtasks
subways1536162subways
surbase939792surbase
surbases10310002surbases
surpass938282surpass
abbas95918643_abba_s
abbess10509773_abbess
bass66146783___bass
brass75428023__brass
bubals103513843bu_bals
bubba84311803bubba__
bubbies103913513bubbies
bubbles104315963bubbles
busbars1138153busbars
cubbies133312883cubbies
cubbish1635803cubbish
cuirass934973cuirass
cutlass938013cutlass
dubbers124011823dubbers
dubbins12358803dubbins
durbars1077973durbars
hubbies143211563hubbies
hubbubs1342603hubbubs
hubcaps1643543hubcaps
jubas144614223ju_ba_s
jubbah2034353jubba_h
jubhahs2242353jubhahs
jumbals18106533jumbals
kurbash1643803kurbash
lubbers113913723lubbers
lumbars11289763lumbars
nubbins11268023nubbins
nubbles113412433nubbles
nubias8310093nubia_s
numbats1137673numbats
outpass939713outpass
quass144413763qu__ass
rubasse934903ru_basse
rubbers113913193rubbers
rubbies114114113rubbies
rubbish1436303rubbish
rubbles113715113rubbles
rumbas102512013rumba_s
sabals84618863s_abals
sabbat10314713sabba_t
sabbath1445393sabbath
sabbaths1543973sabbaths
sabras85116363sabra_s
sambals115213483sambals
sambars115113843sambars
sambas104219263samba_s
sass45035623s___ass
scubas103710223scuba_s
scumbags1543203scumbags
seabags1037483seabags
shibahs15275643shibahs
sibbs96211903sibb__s
slubbers12349943slubbers
snubbers12326673snubbers
snubness1044373snubness
sobas74424253s_oba_s
sobbers114114263sobbers
strass67117223s_trass
stubbles1236843stubbles
suba64926603su_ba__
subadars11125093subadars
subah106015213su_ba_h
subbed114116673subb_ed
subbing123915583subbing
subbings13238483subbings
subcaste1287853subcaste
subcastes1387493subcastes
subcause1265823subcause
subcauses1346213subcauses
subclans1247413subclans
subdeans1137203subdeans
subdebs1236483subdebs
subduals1156293subduals
subdues1099893subdues
subers85722643su_bers
subfusc1444333subfusc
subfuscs1543753subfuscs
subgoals1145553subgoals
subgums1235893subgums
subheads1496533subheads
sublate9315363sublate
sublates10315003sublates
sublease1038383sublease
subleases1148653subleases
sublets92616703sublets
sublots92410913sublots
submits1139753submits
subnasal1044183subnasal
subnets92512083subnets
suborns939493suborns
subpar1048663subpa_r
subpart11311123subpart
subparts1246903subparts
subphase1555603subphase
subphases1645763subphases
subrace11313003subrace
subraces12313033subraces
subs66037123su_b__s
subsale9310543subsale
subsales10310123subsales
subsets92813103subsets
subsist9311573subsist
subsists1037993subsists
subtaxa1644483subtaxa
subtest9513963subtest
subtests1037533subtests
suburbans1344093suburbans
suburbs1136503suburbs
subvassal1452403subvassal
subway1447073subwa_y
succahs1435323succahs
success1146403success
succuss1134993succuss
sucrase9310343sucrase
sucrases10310253sucrases
sugars7312423su_gars
sukkahs1382703sukkahs
suldans8299723suldans
sulfas9311563sulfa_s
sultans72411833sultans
sumacs105512103su_macs
sumless92611123sumless
summas104313163summa_s
sunback1548153sunback
sunbath1236423sunbath
sunbaths1344383sunbaths
sunbeams1243963sunbeams
sunbows1236023sunbows
sundaes8313093sundaes
sunfast1038503sunfast
sunglass945093sunglass
sunless73013693sunless
sunnahs10326593sunnahs
sunnas63914563sunna_s
sunrays1037083sunrays
suntans72111733suntans
surahs94515543su_rahs
suras55336333su_ra_s
surbased1136613surbased
surras65919533surra_s
suss45229303su___ss
sutras64818593sutra_s
suttas63813793sutta_s
tubas75119583tu_ba_s
tubbers113411253tubbers
turbans939563turbans
unbans81912623_unbans
unbars82113033_unbars
zebrass1834113zebrass

Search took 10 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.390458182.1
2DLD Change Limit1340271688.73315347.2
3Display Results1681680.0632666.7
 (SQL Overall)1786911689.18619452.5
 
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.