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

177 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
ideally113779(None) 
areally10411242areally
dally95324742_d_ally
deadly113811472_deadly
deafly13389122_deafly
dearly104615322_dearly
delly96023872_de_lly
dually103210062_dually
ideal65716392idea_l_
ideality1247152ideality
idealogy1342942idealogy
ideals75012502idea_ls
leally94012612_leally
lineally1137792lineally
really93315612_really
tidally1137932tid_ally
adeptly1344183adeptly
adrenally1344943adrenally
ally76935643___ally
anally9513503_anally
aurally10310543aurally
axially1737233axially
bally105530103__bally
banally1249223banally
basally1237963basally
belly104625493_be_lly
biddably17173543biddably
bipedally1743503bipedally
biyearly1643393biyearly
bleakly1634663bleakly
bridally1446453brid_ally
caecally1547703caecally
cavally1588483cavally
cecally1459393cecally
chally144314293_chally
cheaply1735023cheaply
cleanly1236323cleanly
clearly1236663clearly
coevally1646283coevally
daily95922333_d_aily
deal56347413_dea_l_
dealer74122143_dealer
deals65435343_dea_ls
dealt65234283_dea_lt
deary95826843_dea_ry
deathly14336863_deathly
deathy134210233_deathy
deeply1257013_deeply
deftly1336533_deftly
delay94820633_de_lay
dell56938203_de_ll_
dells66630943_de_lls
dentally121110063_dentally
deploy1237583_deploy
dewily1338343_dewily
dilly94923783_d_illy
dismally1446513dismally
distally1239553distally
dolly96125203_d_olly
drably123511613_drably
drawly134910723_drawly
drolly105411673_drolly
ducally13257413ducally
dully94921633_d_ully
early85324123__early
equally1936873equally
fatally1339893fatally
fealty122910223_fealty
featly123711753_featly
federally1645293federally
felly114922803_fe_lly
filially1447003filially
finally13310103finally
fiscally1646073fiscally
focally15188553focally
fugally1435603fugally
gally95026173__gally
greatly1137613greatly
gyrally1435583gyrally
hideaway1842713hideaway
icefall1254303icefall_
icefalls1344253icefalls
idea59122773idea___
idealess935653idealess
idealise938053idealise
idealism1147013idealism
idealist9310653idealist
idealize1847873idealize
idealless1042953idealless
ideas65919013idea__s
ideate7313683idea_te
ideated9310973ideated
ideates8313733ideates
ideology1345653ideology
idly85617323id___ly
idyll9436713id_yll_
idylls10425253id_ylls
ileal56118083ilea_l_
illegally1343733illegally
illy76925333i___lly
ineptly1245073ineptly
inertly1038543inertly
infall939403infall_
infalls1038943infalls
inwall938343inwall_
inwalls1037283inwalls
irefully1445943irefully
jelly154218253_je_lly
jurally1736963jurally
kelly124617023_ke_lly
lealty92910603_lealty
leanly93811503_leanly
legally1138133legally
liberally1446263liberally
linearly1146793linearly
literally1248343literally
locally12179723locally
loyally13126843loyally
mealy104422183_mea_ly
meanly115412043_meanly
measly113610443_measly
medially14129323medially
mesally12119793mesally
misally121111063misally
modally1338403modally
morally12411493morally
nasally1057443nasally
navally1366473navally
nearly94813733_nearly
neatly93812483_neatly
nelly84618813_ne_lly
nodally1137913nodally
orally93113593_orally
ovally12278443_ovally
pally105727123__pally
papally1437973papally
pearly116414843_pearly
penally121111773penally
radially1239783radially
rally84725903__rally
realty92713693_realty
regally1159873regally
retally10413683retally
rideable1158653rideable
ritually1167483ritually
royally13157733royally
rurally1038303rurally
sally85129713__sally
shelly124414473she_lly
sidewall1244803sidewall_
sidewalls1344283sidewalls
signally1246533signally
sizeably2244683sizeably
smelly114110363sme_lly
squally1937673squally
tally84526863__tally
telly84920823_te_lly
tonally10311373tonally
totally1039893totally
treacly1237093treacly
trevally1446343trevally
unreally1148233unreally
useably1287393useably
usually1066063usually
vagally1435833vagally
vealy115817773_vea_ly
venally13119563venally
virally1339653virally
visually1465493visually
vitally1339673vitally
vocally15188343vocally
wally114625093__wally
weakly1636483_weakly
welly114620013_we_lly
widely133311033wide__ly
yearly125210273_yearly
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.393454684.5
2DLD Change Limit1340271776.45320769.7
3Display Results1771770.0632809.5
 (SQL Overall)1786911776.90925863.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.