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

129 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
badasses113617(None) 
badassed1244271badassed
bagasses1136311bagasses
admasses1135412_admasses
amasses93912852_amasses
baases85218012ba_a_ses
babassus1243062babassus
badass949292bada_s_s
badnesses1239252badnesses
bagasse1035142bagasse_
balases93815432bala_ses
basses85428302b__asses
biasses94911652b_iasses
brasses93818352b_rasses
bypasses1533832bypasses
camasses12388972camasses
harasses11311032harasses
hardasses1346452hardasses
kavasses1544302kavasses
abases85720773_aba_ses
abashes12510373_abashes
abbesses1235333abbesses
abysses1234863_abysses
adages8412953_ada_ges
advises11138973_advises
amassed10388633_amassed
amasser9418733_amasser
amassers10337843_amassers
asses55629283___asses
avgasses1284193avgasses
babassu1153463babass_u
baddies114017873bad_dies
badges103917373bad__ges
badness1039573badnes_s
bagass938933baga_s_s
balances1279973balances
baldnesses1337653baldnesses
bandages12310633banda_ges
banishes131812463banishes
baptises1238923baptises
basaltes10367683basaltes
bases75644353b__a_ses
bashes115631393b__ashes
basset85225383b__asset
bassets96414823b__assets
bassos85313703b__assos
bastes85330383b__astes
bathoses13310463bathoses
batistes1039713batistes
bekisses1434243bekisses
biases84618433b_ia_ses
biassed10418703b_iassed
biogasses1244003biogasses
biomasses1343963biomasses
blesses93812393b_lesses
blisses94911513b_lisses
bolases93315003bola_ses
bosses85925403b__osses
braises93818873b_raises
brashes124518463b_rashes
brassed103612373b_rassed
brassies103613533b_rassies
brisses94314313b_risses
busses85023383b__usses
bypassed1642713bypassed
cadaster1136903cadaster
cadasters1236833cadasters
cadastres1244553cadastres
caddises12329353caddises
calashes13310543calashes
camases114216343cama_ses
canvasses14286043canvasses
carcasses1337483carcasses
caresses10314063caresses
chasses124017503_chasses
classes94717943_classes
dadaisms1245123dadaisms
dadaists1045583dadaists
daises74318983__daises
dashes106124983__dashes
dassies84418663__dassies
degasses10278363degasses
disses75225963__disses
dosses76126273__dosses
emdashes14224303emdashes
endashes12217453endashes
eyasses10388023_eyasses
frasses104314513_frasses
gamashes1456953gamashes
gasses75724783__gasses
gausses8308693ga_usses
glasses84414273_glasses
grasses84117343_grasses
harassed1237113harassed
harasser1137043harasser
harassers1246203harassers
impasses12257523impasses
jackasses2243713jackasses
judases1534443juda_ses
karosses1236493karosses
kvasses14365503_kvasses
landmasses1343213landmasses
lasses64827593__lasses
lavashes1445573lavashes
madames12310063mada_mes
madnesses1239833madnesses
madrases112610003madrases
madrassas12304703madrassas
malaises10312333malaises
masses85028713__masses
matrasses1157293matrasses
megasses11307743megasses
molasses1037233molasses
morasses1038903morasses
passes86030473__passes
pavisses13397103pavisses
quasses16209503_quasses
radishes1269463radishes
radiuses937043radiuses
radwastes1364123radwastes
repasses101810373repasses
rubasses1035493rubasses
sadnesses10310303sadnesses
sasses64124393__sasses
strasses81311443strasses
tasses64826763__tasses
trasses74819323_trasses
vinasses1135703vinasses
wrasses103812593_wrasses

Search took 9 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.686260482.5
2DLD Change Limit1461621297.87318565.0
3Display Results1291290.0632047.6
 (SQL Overall)1786911298.62220725.0
 
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.