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

117 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
quickly253407(None) 
fickly18318532_fickly
juicily1935492juicily
prickly18367892prickly
quacky24376962quack_y
quick204311062quick__
quicken2235152quicken
quicker2247022quicker
quickie2235512quickie
quicks21389302quick_s
quietly1945892quietly
quirkily2442592quirkily
quirky22435532quirk_y
sickly153110482_sickly
slickly1635852slickly
thickly19415572thickly
trickly16369892trickly
blackly1835253blackly
brickle15279933brickle
bricky17489093brick_y
briskly16165403briskly
buckle144815193bu_ckle
buirdly1334213buirdly
chicly16429203chic_ly
cicely1338833_cicely
crackly18397703crackly
crickey18418143crickey
crinkly16387523crinkly
cubicly1644993cubic_ly
dickey165913523_dickey
dicky154816243_dick_y
dinkly144311083_dinkly
ducky154216113du_ck_y
equinely2044643equinely
feckly18335963_feckly
fickle153912973_fickle
freckly19124593freckly
hackly18298733_hackly
hickey185011993_hickey
huckle153913073hu_ckle
icily101211693__icily
ickily1535753__ickily
icky136315753__ick_y
juicy1738283juic__y
kicky135012333_kick_y
knuckly1542473knuckly
lucidly13125213lucidly
luckily16297083lu_ckily
lucky145515013lu_ck_y
mickey174211853_mickey
mickle143715133_mickle
muchly1686203mu_chly
muckily18277743mu_ckily
muckle143413583mu_ckle
mucky165015253mu_ck_y
murkly15368303mu_rkly
muscly1337453musc_ly
nicely1139493_nicely
nickle123814483_nickle
packly17228333_packly
pickle144215653_pickle
picky165416943_pick_y
pinkly155012243_pinkly
pricily142710283pricily
prickle153611013prickle
pricky174210343prick_y
quack203812503quack__
quacked2336793quacked
quackery2633113quackery
quacks214710103quack_s
quaintly2065023quaintly
quakily2336693quakily
quaky214310743qu_ak_y
queenly1944463queenly
queerly1934233queerly
quibble2034713quibble
quiche2057903quic_he
quiches2139333quiches
quickens2334253quickens
quickest2345343quickest
quickies2336773quickies
quicklime2641823quicklime
quickset2345363quickset
quill148413773qui__ll
quills153811853qui_lls
quilt144125103qui__lt
quinary1936933quinary
quinela1635213quinela
quinol15357973quinol_
quinols16297243quinols
quinsy18386353qui_nsy
quippy22384263qui_ppy
quirk184011003quirk__
quirked21325433quirked
quirks19419113quirk_s
quivery22265463quivery
richly1438003_richly
rickey154613973_rickey
ruckle124414583ru_ckle
sickle124418323_sickle
slackly1635263slackly
spicily1438653spicily
squiggly2242503squiggly
stickily1736083stickily
stickle132410973stickle
sticky154711343stick_y
suckle124015963su_ckle
sucky144415503su_ck_y
tickle124616743_tickle
tinkly134811153_tinkly
trickily1736233trickily
trickle133613443trickle
tricksy16436583tricksy
tricky154211473trick_y
twinkly1733913twinkly
wrinkly17295753wrinkly
yucky175411693yu_ck_y

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.406440125.6
2DLD Change Limit1340271176.97019229.1
3Display Results1171170.0432720.9
 (SQL Overall)1786911177.41924085.6
 
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.