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

199 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
basally123796(None) 
banally1249221banally
nasally1057441nasally
anally9513502_anally
bally105530102b__ally
basal75722282basa_l_
basalt83519582basa_lt
basalts9358962basalts
basely114412312bas_ely
basically1648032basically
bassly114610072bas_sly
casually1356822casually
causally1356612causally
cavally1588482cavally
fatally1339892fatally
mesally12119792mesally
misally121111062misally
navally1366472navally
papally1437972papally
rascally1347732rascally
sally85129712__sally
vagally1435832vagally
abasedly1443343abasedly
aborally1347063aborally
abysmally1951813abysmally
ally76935643___ally
areally10411243areally
astrally1148883_astrally
aurally10310543aurally
axially1737233axially
baal67033113ba_a_l_
baalim1038473ba_alim
baals76122703ba_a_ls
bacalao1146613bacalao
bacilli1146393bacilli
badly114918763b__adly
baggily1436043baggily
bailey115015673ba_iley
bairnly1234503bairnly
baldly12479833ba_ldly
baldy115518933b__aldy
balkily16266693balkily
balky145418243b__alky
ball66043323b__all_
balls76236413b__alls
ballsy11508873ba_llsy
balmily14216463balmily
balmy125217473b__almy
banal75925993bana_l_
banality1338763banality
barely114716793ba_rely
barfly14339653ba_rfly
barilla9310323barilla
barley115116763ba_rley
basaltes10367683basaltes
basaltic1245153basaltic
bascule1136573bascule
baseball1245623baseball_
baseballs1344783baseballs
bashfully2043843bashfully
bashlyk1942463bashlyk
basify1437513bas_ify
basil75122273bas_il_
basilar937303basilar
basilary1345063basilary
basilic1137493basilic
basils85717473bas_ils
bassy1012917103bas__sy
bastardly15264293bastardly
bastardy14326003bastardy
bastile9313913bastile
bastille1047993bastille
baulky15446313ba_ulky
bawdily1635803bawdily
bearably15177933bearably
beastly1277563beas_tly
befall114410643befall_
befalls12349123befalls
begall92610723begall_
begalls10319163begalls
belly104625493b__elly
bestially1447043bestially
bialy105119323b_ia_ly
biasedly1443953biasedly
biaxially2143693biaxially
billy105525363b__illy
blamably1744903blamably
bleakly1634663bleakly
bossily1237563bossily
brashly15427613bras_hly
brassily1336623brassily
brawly144312353b_rawly
bridally1446453bridally
broadly1337153broadly
brolly114510853b_rolly
brutally1345743brutally
buccally1744623buccally
bully105124813b__ully
bushily15268893bushily
busily112211503bus_ily
caecally1547703caecally
capably1639253capably
carnally1339513carnally
casualty1344473casualty
caudally1446463caudally
cavalla1257883cavalla
cavalry1554963cavalry
cecally1459393cecally
chally144314293_chally
coastally1446503coastally
costally1339733costally
dally95324743__dally
dismally1446513dismally
distally1239553distally
dorsally1246833dorsally
dually103210063_dually
ducally13257413ducally
easily9313023eas_ily
equally1936873equally
facially1637643facially
faunally1445433faunally
festally1437543festally
finally13310103finally
fiscally1646073fiscally
focally15188553focally
fugally1435603fugally
gally95026173__gally
gassily1137813gassily
gyrally1435583gyrally
hastily133010663hastily
hazelly2254383hazelly
ideally1137793ideally
jurally1736963jurally
labially1336983labially
laically1338983laically
lastly93310873las_tly
leally94012613_leally
legally1138133legally
locally12179723locally
loyally13126843loyally
manually1347043manually
masala8311813masa_la
masalas9312053masalas
mesially13119083mesially
modally1338403modally
morally12411493morally
nasal56217593nasa_l_
nasality1146653nasality
nasals63312463nasa_ls
nastily103011033nastily
nodally1137913nodally
orally93113593_orally
ovally12278443_ovally
pally105727123__pally
passably1537253passably
payably17177093payably
penally121111773penally
phrasally1742823phrasally
postally13310273postally
racially1339623racially
radially1239783radially
rally84725903__rally
rashly123410213ras_hly
ratably121711513ratably
ravelly13268353ravelly
really93315613_really
regally1159873regally
retally10413683retally
royally13157733royally
rurally1038303rurally
sadly94519123__sadly
salably121610743salably
sall44544683__sall_
salty85524383__salty
sassily1038723sassily
silly84527623__silly
squally1937673squally
sully84622903__sully
tally84526863__tally
tarnally1138273tarnally
tastily103311643tastily
taxably1936043taxably
tidally1137933tidally
tonally10311373tonally
totally1039893totally
usably11288983_usably
usually1066063usually
vasal85516293vasa_l_
vastly12508723vas_tly
venally13119563venally
vestally1437413vestally
virally1339653virally
visually1465493visually
vitally1339673vitally
vocally15188343vocally
wally114625093__wally
waspily1535513waspily
weaselly14284373weaselly
zonally1938003zonally

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.403443402.0
2DLD Change Limit1340271996.14321817.8
3Display Results1991990.0762618.4
 (SQL Overall)1786911996.62226984.4
 
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.