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

277 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
bassist931274(None) 
assist6314601_assist
bassists1037181bassists
assists738472_assists
baptist11311872baptist
basest84720492ba_sest
basis75429862ba_sis_
basses85428302basses_
basset85225382bass_et
bassets96414822bassets
bassett94213862bassett
bassi77019322bassi__
bassinet10312842bassinet
bassos85313702bassos_
bossiest103112212bossiest
bossism1136062bossism
brassiest11369712brassiest
brassish1346432brassish
cassis84818852cassis_
casuist9411302casuist
classist104010382classist
coassist10298802coassist
fascist1239212fascist
gassiest93212522gassiest
lassis65216702lassis_
massiest103314422massiest
sassiest83413612sassiest
ableist9311773ableist
abscise1145953abscise
ageist7315383_ageist
agist66325583_a_gist
alist56136783_a_list
aorist64827873_aorist
apsis75718293_apsis_
arsis55722423_arsis_
artist64125543_artist
ashiest10313953_ashiest
aspis74618143_aspis_
aspish114810333_aspish
assais6711963_assais_
assent65119953_assent
assert64922583_assert
asses55629283_asses_
assess65710463_assess
asset55932263_ass_et
assets65617663_assets
assign736783_assign
assisted936233_assisted
assister836753_assister
assistor844823_assistor
assize1538633_assize
assort64916383_assort
aurist65027253_aurist
autist64324943_autist
baalism11310593baalism
baases85218013baases_
babbitt1038033babbitt
babiest114414753babiest
babyish1736513babyish
babysit14145613babysi_t
babysits15143543babysits
backlist16910653backlist
baddest112611143baddest
baggiest123011753baggiest
bait66556003ba__i_t
baits76630583ba__its
bakshish2043743bakshish
baldest102313533baldest
baldish1339503baldish
balkiest144112453balkiest
ballast9313993ballast
ballista1045803ballista
ballsiest1145413ballsiest
balmiest124110993balmiest
balsas86417523balsas_
bandit93821133bandi_t
bandits103814793bandits
banish111416043ba_nish
banjoist1745143banjoist
bankit123617043banki_t
bankits133410153bankits
baptise1139553baptise
baptism1337803baptism
baptists1236723baptists
barest85327693ba_rest
barista9310813ba_rista
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
basalt83519583ba_salt
basalts9358963basalts
bases75644353ba_ses_
bashes115631393bashes_
bashing135422583bashing
basic96220523ba_si_c
basics104915123ba_sics
basify1437513ba_sify
basil75122273ba_si_l
basilisk1444053basilisk
basils85717473ba_sils
basin75026923ba_si_n
basinet9318933basinet
basing95427663ba_sing
basins85722763ba_sins
basion84315853ba_sion
basket125722913ba_sket
baskets135111833baskets
basking144718613basking
basks115621763ba_sks_
bass66146783ba_s_s_
bassetts10407373bassetts
bassinets1146323bassinets
bassly114610073bass_ly
bassness1096743bassness
basso76017283ba_s_so
bassoon937613bassoon
bassoonist1253333bassoonist
bassy1012917103ba_s_sy
bast66362413ba___st
bastes85330383bastes_
bastile9313913bastile
basting104227203basting
bastion9312473bastion
basts75936933ba_sts_
batfish1558683batfish
batiste939743ba_tiste
battiest104115553battiest
bawdiest14398673bawdiest
bawsunt1244723bawsunt
bedsit9312843bedsi_t
bedsits1037563bedsits
bemist105216953b_emist
biasses94911653biasses_
biassing11307263biassing
biblist11310833biblist
bitsiest102610063bitsiest
blastiest111710043blastiest
boskiest14289733boskiest
bosses85925403bosses_
bossier93712423bossier
bossies94116833bossies
bossily1237563bossily
bossing103714603bossing
bossisms1244703bossisms
brashest133511763brashest
brashiest14359853brashiest
brassart1047503brassart
brasses93818353brasses_
brassica1244873brassica
brassie93411523brassi_e
brassier103310533brassier
brassies103613533brassies
brassily1336623brassily
brassing112612303brassing
bundist10310193bundist
bushiest133512523bushiest
busiest93716303busiest
busses85023383busses_
bussing103614623bussing
bustiest102815053bustiest
byssi10507993byssi__
byssus1133763byssus_
cambist13312113cambist
cassia83714763cassi_a
cassias93514343cassias
cassina94113163cassina
cassine93817283cassine
cassino93512433cassino
cassises103811743cassises
casuists1036523casuists
chassis123910663chassis_
classiest11309543classiest
classis93712723classis_
classism12407173classism
classists11296243classists
coassists11275763coassists
consist9316033consist
cosmist11311333cosmist
crassest103411523crassest
dadaist9310103dadaist
dashiest12311113dashiest
dashis104414393dashis_
dassie74615573dassi_e
dassies84418663dassies
desist74818813_desist
easiest72318773easiest
faddist12289643faddist
falsest10310013falsest
fascism1436443fascism
fascists1336613fascists
fastest102413723fastest
fauvist1336663fauvist
fussiest112910493fussiest
gashest114813413gashest
gaslit7513503gasli_t
gasses75724783gasses_
gassier83812573gassier
gassily1137813gassily
gassing94216333gassing
glassiest10279243glassiest
grassiest10309513grassiest
harpist12312353harpist
hashish1238353hashish
hassium1236133hassium
hastiest112916493hastiest
hissiest112911093hissiest
insist6314513_insist
jassid1467223jassi_d
jassids1586143jassids
lasses64827593lasses_
lassi56316853lassi__
lassie64917743lassi_e
lassies74420103lassies
lassos64913813lassos_
maist75535683ma__ist
massas85116463massas_
masses85028713masses_
massicot1246583massicot
massier93615223massier
massif11412533massi_f
massifs1237743massifs
massing104318023massing
massive12289773massive
messiest103112423messiest
missis84417503missis_
mossiest103112443mossiest
mussiest103112933mussiest
narcist9512443narcist
nastiest83615953nastiest
oasis56422553oa_sis_
palmist112814343palmist
papist102618743pa_pist
passant9813943passant
passes86030473passes_
passim10410283passi_m
passing104318423passing
passion9310883passion
passive12239593passive
passivist1445993passivist
passus83610293passus_
pastiest103319543pastiest
pastis84924323pastis_
persist9315853persist
pussiest102911753pussiest
racist82822793ra_cist
rapist82520673ra_pist
rashest103916873rashest
raspiest10311273raspiest
raspish1298103raspish
resist64524533_resist
sacrist9315423sacrist
sadist74221353sa_dist
sasses64124393sasses_
sassier73413233sassier
sassies74719263sassies
sassily1038723sassily
sassing84615553sassing
shist84829613__shist
sissiest83412353sissiest
subsist9311573subsist
tachist12613293tachist
tanist6324593ta_nist
tasses64826763tasses_
tasset65925313tass_et
tassets75012773tassets
tassie66017023tassi_e
tassies74918933tassies
tastiest83216633tastiest
tsarist7712253tsarist
tussis6379953tussis_
vastest102911513vastest
vastiest112713073vastiest
waist86132383wa__ist
washiest14310403washiest
waspiest1338813waspiest
waspish1586923waspish
wussiest11268663wussiest

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272776.94019312.2
3Display Results2772770.0932978.5
 (SQL Overall)1786912777.18624866.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.