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

347 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
hickeys1950822(None) 
dickeys17479301dickeys
hickey185011991hickey_
hockeys19509271hockeys
mickeys18447941mickeys
rickeys16548981rickeys
bickers154316552bickers
chickees19258512chickees
chickens19267432chickens
dickens144410132dickens
dickers144117662dickers
dickey165913522dickey_
dinkeys15507262dinkeys
hackees165014102hackees
hackers164619042hackers
hackneys2033682hackneys
hawkeys20414702hawkeys
hickies163614742hickies
hicks145322172hick__s
hikers135014352hi_kers
hikes125426982hi_ke_s
hockers163915912hockers
hockey184813152hockey_
honkeys17439512honkeys
hookeys17448952hookeys
hunkeys17386192hunkeys
ickers123914182_ickers
jockeys23365952jockeys
kickers124013292kickers
lackeys16458262lackeys
lickers134118252lickers
mickey174211852mickey_
nickels13338652nickels
nickers134415092nickers
pickers153718092pickers
pickets154314182pickets
pinkeys16378212pinkeys
rickets134915092rickets
rickey154613972rickey_
shickers173012822shickers
sickees134514212sickees
sickens134411482sickens
thickens17266412thickens
thickets17287082thickets
tickers133617722tickers
tickets134113682tickets
whickers20297982whickers
whiskeys21353382whiskeys
wickers164114702wickers
wickets164010942wickets
ackees124914583_ackees
backers153821883backers
beckets15399823beckets
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
buckers153517453buckers
buckets153811693buckets
buckeye1835683buckeye
buckeyes1945263buckeyes
checkers19317843checkers
chickee183111553chicke_e
chicken18278983chicke_n
chickpeas2242953chickpeas
chicks175317593chick__s
chicles143512503chicle_s
chicness1535593chicness
chimleys1883633chimleys
chimneys1883643chimneys
clickers163910203clickers
cockers153618333cockers
cockeye1867223cockeye
cockeyes1967033cockeyes
cockneys1934493cockneys
cookeys16478503cookeys
crickets16418123crickets
crickey18418143crickey_
dackers143417043dackers
darkeys15356533darkeys
deckels14367363deckels
deckers144413833deckers
dicers94720743dic_ers
dices86434243dic_e_s
dicey114819333dic_ey_
dicked144920863dicke_d
dicker134521403dicke_r
dickies143416343dickies
dicks125824693dick__s
dicky154816243dick_y_
dikers114418793di_kers
dikes105831333di_ke_s
dikey135116423di_key_
dingeys12458403dingeys
dinkey144812763dinkey_
dockers143715003dockers
dockets144412243dockets
donkeys15426663donkeys
doohickeys2310903doohickeys
duckers143214713duckers
fices106031163fic_e_s
fiches145219533fiche_s
fickly18318533fickly_
ficoes114613463ficoe_s
flickers17338883flickers
fuckers163611593fuckers
haceks15447863hac_eks
hacked164923513hacke_d
hackee154921833hacke_e
hacker154822693hacke_r
hackies163418243hackies
hacklers173710303hacklers
hackles162917063hackles
hackly18298733hackly_
hackney1935123hackney_
hacks144928713hack__s
hakes126034303h_ake_s
hankers144218133hankers
harkens144112863harkens
hawkers174210333hawkers
hawkey19507633hawkey_
hecklers17357123hecklers
heckles163711383heckles
hecks145220653heck__s
henleys1334843henleys
heydeys1732863heydeys
hiccups1643223hiccups
hick135530303hick___
hickie153812473hick_ie
hickish1936473hickish
hickory1943903hickory
hiders104919653hi_ders
hides95129423hi_de_s
hies74842833hi__e_s
hijackers2542323hijackers
hike116830393hi_ke__
hiked135919203hi_ke_d
hiker125119393hi_ke_r
hillers103718733hillers
hinders113718503hinders
hingers113420213hingers
hinges105121033hinge_s
hinky155618753hink_y_
hinters103719583hinters
hipless12399923hipless
hipness12277383hipness
hirees95117293hi_rees
hirers94518063hi_rers
hires86134343hi_re_s
hirsels10128343hirsels
hissers104112313hissers
hisses94719353hisse_s
hitchers16379993hitchers
hitches153616273hitche_s
hitless103211193hitless
hitters104717593hitters
hives116925513hi_ve_s
hocked165521303hocke_d
hocker155118563hocke_r
hocks144925493hock__s
hoicked1735963hoicke_d
hoicks15378283hoick__s
hokes126231643h_oke_s
hokey155422183h_okey_
homeys145012873h_omeys
honeys124016083h_oneys
honkers143315233honkers
honkey165113823honkey_
hooeys125512313h_ooeys
hookers144916513hookers
hookey164713933hookey_
hoseys124614003h_oseys
huckles163612623huckles
hucks144322173huck__s
hunkers143314333hunkers
hunkey164210883hunkey_
hurleys13407333hurleys
huskers143510043huskers
ices66129643_ic_e_s
icker114018443_icke_r
icky136315753_ick_y_
inkers104018833_inkers
jackers204214453jackers
jackets205011373jackets
jinkers183511813jinkers
jitneys17313173jitneys
jockey22408033jockey_
keys116322163___keys
kicked124415943kicke_d
kicker114116183kicke_r
kicks104420083kick__s
kickups1443503kickups
kicky135012333kick_y_
kidneys1533423kidneys
kikes85122553ki_ke_s
knickers13306723knickers
lackers134120543lackers
lackey154813353lackey_
lichees123512783lichees
lichens123510683lichens
liches114724293liche_s
licked134621563licke_d
licker125222043licke_r
licks115325393lick__s
likens105613703li_kens
likers104620913li_kers
likes96231903li_ke_s
limeys11429273li_meys
linkers114317713linkers
linseys1035083linseys
lockers133516923lockers
lockets134612203lockets
miches134320733miche_s
mickles153415003mickles
micks135525373mick__s
mikes115129893mi_ke_s
milkers134411613milkers
minkes124618783minke_s
mockers153812943mockers
monkeys16407423monkeys
muckers153612803muckers
neckers134210463neckers
niches114419143niche_s
nicked135019683nicke_d
nickel123811343nicke_l
nicker123818703nicke_r
nickles133713823nickles
nicks114920493nick__s
ockers123813903_ockers
packers153818893packers
packets155114773packets
peckers153312673peckers
picked154421313picke_d
pickeer153710113pickeer
pickeers16347243pickeers
picker144422173picke_r
picket144924313picke_t
pickles153215443pickles
picks135226143pick__s
pickups1754253pickups
picky165416943pick_y_
pikers124717393pi_kers
pikes115031033pi_ke_s
pinkens13419643pinkens
pinkers134118603pinkers
pinkey154314673pinkey_
pinkeye16326493pinkeye
pinkeyes17335973pinkeyes
pockets154612253pockets
pokeys15529513_pokeys
prickers163710673prickers
prickets16329083prickets
puckers153514673puckers
punkeys16366493punkeys
quickens2334253quickens
rackers134320453rackers
rackets134916873rackets
rekeys13347693_rekeys
ricers84120993ric_ers
rices75536153ric_e_s
richens12349733richens
riches115022083riche_s
ricked136523623ricke_d
rickety16478313rickety
ricks115126133rick__s
ridleys11145783ridleys
riskers114011993riskers
rockers133916553rockers
rockets134615363rockets
sackers133820223sackers
shicker163914823shicke_r
shicksas1743523shicksas
shikkers14326523shikkers
shinneys14275093shinneys
shirkers15319583shirkers
shockers17319463shockers
shuckers17388133shuckers
sices75637273sic_e_s
sickbays1943163sickbays
sickbeds17254213sickbeds
sicked134524403sicke_d
sickee124622223sicke_e
sicken124615253sicke_n
sicker124023903sicke_r
sickest131813793sickest
sickies133717503sickies
sickles133417543sickles
sickly153110483sickly_
sickness1437833sickness
sickos125112033sick_os
sicks115127623sick__s
sikes96236083si_ke_s
sinkers113618543sinkers
slickens14317263slickens
slickers143112553slickers
snickers143010963snickers
sockets134012983sockets
sockeye1666413sockeye
sockeyes1765763sockeyes
stickers142913033stickers
suckers133717623suckers
tackers134319623tackers
tackets134914363tackets
tackey154613083tackey_
thicken16317873thicke_n
thicker163611023thicke_r
thickest17337303thickest
thicket163213073thicke_t
thickety20274103thickety
thickly19415573thickly_
thickness1844443thickness
thicks154511993thick__s
thicksets18263733thicksets
thinkers15308703thinkers
ticked134720523ticke_d
ticker124321503ticke_r
ticket124524853ticke_t
ticklers14339303ticklers
tickles133416853tickles
ticks115823293tick__s
tikes95628903ti_ke_s
tinkers113517143tinkers
trickers143812813trickers
tuckers134014353tuckers
tuckets134810333tuckets
turkeys1434523turkeys
vices105725533vic_e_s
wackes154717713wacke_s
whackers20326543whackers
whicker19359773whicke_r
whimseys19322463whimseys
whiskers18306773whiskers
whiskey20445583whiskey_
whiteys16396153whi_teys
wiches144418753wiche_s
wicked164317413wicke_d
wicker154518673wicke_r
wicket155318943wicke_t
wickless1736083wickless
wicks144619363wick__s
wifeys15425873wi_feys
winceys15395523winceys
winkers143517113winkers
witneys13274723witneys
yikes125117753yi_ke_s

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.436409841.7
2DLD Change Limit1340273475.67323625.4
3Display Results3473470.1232821.1
 (SQL Overall)1786913476.23228673.1
 
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.