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

176 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
thickly1941557(None) 
trickly16369891trickly
chicly16429202chic_ly
fickly18318532_fickly
hackly18298732_hackly
hickey185011992_hickey
prickly18367892prickly
quickly2534062quickly
sickly153110482_sickly
slickly1635852slickly
thick145613352thick__
thicken16317872thicken
thicker163611022thicker
thicket163213072thicket
thickety20274102thickety
thicks154511992thick_s
thinly1238672thi_nly
thirdly1444622thirdly
thistly1395962thistly
tickle124616742t_ickle
tinkly134811152t_inkly
trickily1736232trickily
trickle133613442trickle
tricksy16436582tricksy
tricky154211472trick_y
twinkly1733912twinkly
blackly1835253blackly
brickle15279933brickle
bricky17489093brick_y
briskly16165403briskly
chick165419133chick__
chickee183111553chickee
chicken18278983chicken
chickory2243363chickory
chicks175317593chick_s
chicle134312543chic_le
chicory1735993chicory
chiefly1834103chiefly
childly1644803childly
chilly144113223chi_lly
chimbly1974593chimbly
chinky185610543chink_y
choicely1843823choicely
chuckle1836443chuckle
chucky20418003chuck_y
cicely1338833_cicely
crackly18397703crackly
crickey18418143crickey
crinkly16387523crinkly
dickey165913523_dickey
dicky154816243_dick_y
dinkly144311083_dinkly
ethical1238443ethical_
ethically1748703ethically
ethicals1345533ethicals
feckly18335963_feckly
fickle153912973_fickle
freckly19124593freckly
hackle154916813_hackle
heckle153112093_heckle
hick135530303_hick__
hickeys19508223_hickeys
hickie153812473_hickie
hickory1943903_hickory
hicks145322173_hick_s
highly1636823_highly
hilly114422163_hi_lly
hinky155618753_hink_y
hiply134113613_hi_ply
hockey184813153_hockey
huckle153913073_huckle
icily101211693__icily
ickily1535753__ickily
icky136315753__ick_y
juicily1935493juicily
kicky135012333_kick_y
knuckly1542473knuckly
mickey174211853_mickey
mickle143715133_mickle
nicely1139493_nicely
nickle123814483_nickle
packly17228333_packly
pickle144215653_pickle
picky165416943_pick_y
pinkly155012243_pinkly
pricily142710283pricily
prickle153611013prickle
pricky174210343prick_y
richly1438003_richly
rickey154613973_rickey
shackle16409543shackle
shicker163914823shicker
shicksa1634103shicksa
shily115222013shi__ly
shingly143210813shingly
shinily13268933shinily
shticky19344473shtick_y
sickle124418323_sickle
slackly1635263slackly
spicily1438653spicily
stickily1736083stickily
stickle132410973stickle
sticky154711343stick_y
strickle1467793strickle
strictly1345813strictly
tacitly1236223tacitly
tackey154613083t_ackey
tackily1637503t_ackily
tackle123815733t_ackle
tacky145617443t_ack_y
talcky15294723talck_y
thack144915173thack__
thacked173810203thacked
thacks154311923thack_s
thecal113310303thecal_
thegnly1442613thegnly
thickens17266413thickens
thickest17337303thickest
thickets17287083thickets
thickish2044603thickish
thickset17257133thickset
thill85918733thi__ll
thills95515383thi_lls
thimble1435873thimble
think125018803think__
thinkably2142633thinkably
thinker143610683thinker
thinks134613363think_s
thiol87616043thi_ol_
thiols95112763thi_ols
thionyl1343713thionyl
thirl85416823thi_rl_
thirls95012063thi_rls
thirsty1354083thirsty
thirty12378403thi_rty
thistle10107803thistle
thusly1235133th_usly
tical76021493t_ical_
ticals83214713t_icals
tick106231223t_ick__
ticked134720523t_icked
ticker124321503t_icker
ticket124524853t_icket
tickled144313133t_ickled
tickler133612653t_ickler
tickles133416853t_ickles
ticks115823293t_ick_s
tiddly11308783t_iddly
tidily102811393t_idily
timely113410113t_imely
tingly103815973t_ingly
tinily94014433t_inily
tinkle103714453t_inkle
trick115420693trick__
tricked144016163tricked
tricker134615523tricker
trickery17297343trickery
trickie132611033trickie
trickled152610433trickled
trickles143013763trickles
tricks125319013trick_s
trigly103810943tri_gly
trimly114410893tri_mly
triply114211023tri_ply
tritely1039003tritely
truckle13358863truckle
twiddly15233773twiddly
twinkle1464773twinkle
twirly12427083twi_rly
whacky21556493whack_y
whicker19359773whicker
whirly15448863whi_rly
whiskey20445583whiskey
whisky19455903whisk_y
whitely16346473whitely
wrinkly17295753wrinkly

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.1561145455.1
2DLD Change Limit1340271767.56317721.4
3Display Results1761760.0632793.7
 (SQL Overall)1786911767.78222962.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.