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

156 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
usually106606(None) 
casually1356822casually
dually103210062_dually
equally1936872equally
mutually1345202mutually
sally85129712_s_ally
squally1937672squally
suably112814532_suably
sully84622902_su_lly
unusually1243332unusually
usably11288982us_ably
useably1287392useably
usual5310182usua_l_
usuals637792usua_ls
visually1465492visually
actually1366853actually
ally76935643___ally
anally9513503_anally
annually1145833annually
areally10411243areally
asexually1943783asexually
astrally1148883astrally
aurally10310543aurally
axially1737233axially
bally105530103__bally
banally1249223banally
basally1237963basally
brutally1345743brutally
buccally1744623buccally
bully105124813_bu_lly
casualty1344473casualty
caudally1446463caudally
causally1356613causally
cavally1588483cavally
cecally1459393cecally
chally144314293_chally
costally1339733costally
cruelly1236563cruelly
cully105520463_cu_lly
dally95324743__dally
dismally1446513dismally
distally1239553distally
ducally13257413ducally
dully94921633_du_lly
equably2136183equably
fatally1339893fatally
faunally1445433faunally
festally1437543festally
feudally1554823feudally
finally13310103finally
fiscally1646073fiscally
focally15188553focally
foully1239013fou_lly
frugally1544403frugally
fugally1435603fugally
fully114820863_fu_lly
gally95026173__gally
gully94020683_gu_lly
gyrally1435583gyrally
ideally1137793ideally
issuably1344963issuably
jurally1736963jurally
leally94012613_leally
legally1138133legally
locally12179723locally
loyally13126843loyally
manually1347043manually
mesally12119793mesally
mesially13119083mesially
misally121111063misally
modally1338403modally
morally12411493morally
musically1647853musically
nasally1057443nasally
navally1366473navally
neurally1137933neurally
nodally1137913nodally
nounally1146483nounally
orally93113593_orally
ovally12278443_ovally
pally105727123__pally
papally1437973papally
penally121111773penally
plurally1345813plurally
postally13310273postally
pulpally1544453pulpally
qualmy20285803_qualmy
rally84725903__rally
rascally1347733rascally
really93315613_really
regally1159873regally
retally10413683retally
ritually1167483ritually
royally13157733royally
rurally1038303rurally
sadly94519123_s_adly
sall44544683_s_all_
salty85524383_s_alty
scall74420373_scall_
scalls84218203_scalls
scaly104718723_sca_ly
sensually1245313sensually
sexually1845613sexually
shaley123714993_shaley
shall85024053_shall_
shaly114322863_sha_ly
shelly124414473_shelly
silly84527623_s_illy
small74016263_small_
smalls84514123_smalls
smelly114110363_smelly
snarly93815003_snarly
spall74919303_spall_
spalls84217343_spalls
squall1538003squall_
squalls1647313squalls
squatly1946433squatly
stably113314123_stably
stalely1039213_stalely
stalky13499303_stalky
stall54722353_stall_
stalls64019933_stalls
stilly93714093_stilly
suable83920553_suable
suavely1376493_suavely
subtly11249263_subtly
sulky124715363_su_lky
supply1346893_supply
surely93816463_surely
surlily10310003_surlily
surly85124433_su_rly
suturally1245953suturally
tally84526863__tally
tidally1137933tidally
tonally10311373tonally
totally1039893totally
uncially1339073uncially
unequally2144193unequally
unmanly1236993unmanly
unreally1148233unreally
unstably1339493unstably
unsubtly1343093unsubtly
unsurely1146383unsurely
usable84012553us_able
useable9911063useable
usefully1444593usefully
usury887623usu__ry
uvularly1442693uvularly
vagally1435833vagally
venally13119563venally
vestally1437413vestally
virally1339653virally
vitally1339673vitally
vocally15188343vocally
wally114625093__wally
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.406440125.6
2DLD Change Limit1340271565.90622693.4
3Display Results1561560.0463391.3
 (SQL Overall)1786911566.35828104.9
 
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.