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

160 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
nasally105744(None) 
basally1237961basally
navally1366471navally
anally9513502_anally
banally1249222banally
casually1356822casually
causally1356612causally
cavally1588482cavally
fatally1339892fatally
mesally12119792mesally
misally121111062misally
nasal56217592nasa_l_
nasality1146652nasality
nasals63312462nasa_ls
nastily103011032nastily
nodally1137912nodally
papally1437972papally
rascally1347732rascally
sally85129712__sally
vagally1435832vagally
ally76935643___ally
animally1368643animally
annually1145833annually
anodally1246293anodally
areally10411243areally
astrally1148883_astrally
aurally10310543aurally
axially1737233axially
bally105530103__bally
basal75722283basa_l_
basalt83519583basa_lt
basalts9358963basalts
basely114412313bas_ely
basically1648033basically
bassly114610073bas_sly
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
nacelle938153nacelle
naively1335903naively
nakedly1534403nakedly
namable11312343namable
namely113711323na_mely
napalm1047263napa_lm
napalms1144033napalms
nasalise848863nasalise
nasalism1048203nasalism
nasalize1748183nasalize
nasial6413283nasial_
nasty85717283nas__ty
natal53921493nata_l_
natality1139193natality
natantly1144293natantly
nattily103610323nattily
naturally1246523naturally
naval85315833nava_l_
naysay1234973naysa__y
nearly94813733n_early
neatly93812483n_eatly
nelly84618813n__elly
neurally1137933neurally
normally1347883normally
nosily93712683nos_ily
notably12199993notably
nounally1146483nounally
novelly1346513novelly
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
uncially1339073uncially
unreally1148233unreally
unusually1243333unusually
usably11288983_usably
usually1066063usually
vasal85516293vasa_l_
vastly12508723vas_tly
venally13119563venally
vestally1437413vestally
virally1339653virally
visually1465493visually
vitally1339673vitally
vocally15188343vocally
wally114625093__wally
waspily1535513waspily
weaselly14284373weaselly
zonally1938003zonally

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.403443402.0
2DLD Change Limit1340271606.92319359.7
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.38924183.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.