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

360 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
dickeys1747930(None) 
dickens144410131dickens
dickers144117661dickers
dickey165913521dickey_
dinkeys15507261dinkeys
hickeys19508221hickeys
mickeys18447941mickeys
rickeys16548981rickeys
bickers154316552bickers
dackers143417042dackers
darkeys15356532darkeys
deckels14367362deckels
deckers144413832deckers
dicers94720742dic_ers
dices86434242dic_e_s
dicey114819332dic_ey_
dicked144920862dicke_d
dicker134521402dicke_r
dickies143416342dickies
dicks125824692dick__s
dicky154816242dick_y_
dikers114418792di_kers
dikes105831332di_ke_s
dikey135116422di_key_
dingeys12458402dingeys
dinkey144812762dinkey_
dockers143715002dockers
dockets144412242dockets
donkeys15426662donkeys
duckers143214712duckers
hickey185011992hickey_
hockeys19509272hockeys
ickers123914182_ickers
jockeys23365952jockeys
kickers124013292kickers
lackeys16458262lackeys
lickers134118252lickers
mickey174211852mickey_
nickels13338652nickels
nickers134415092nickers
pickers153718092pickers
pickets154314182pickets
pinkeys16378212pinkeys
rickets134915092rickets
rickey154613972rickey_
sickees134514212sickees
sickens134411482sickens
tickers133617722tickers
tickets134113682tickets
wickers164114702wickers
wickets164010942wickets
ackees124914583_ackees
backers153821883backers
beckets15399823beckets
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
buckers153517453buckers
buckets153811693buckets
buckeye1835683buckeye
buckeyes1945263buckeyes
chickees19258513chickees
chickens19267433chickens
clickers163910203clickers
cockers153618333cockers
cockeye1867223cockeye
cockeyes1967033cockeyes
cockneys1934493cockneys
cookeys16478503cookeys
crickets16418123crickets
crickey18418143crickey_
daces85030683dac_e_s
dacker134920753dacke_r
daikers124010313daikers
darkens12409873darkens
darkey145212423darkey_
decays124612913dec_ays
decked145217623decke_d
deckel134911043decke_l
decker135215993decke_r
deckles143312803deckles
decks124822193deck__s
decoys123911283dec_oys
decrees102513123decrees
deicers103612733deic_ers
deices94119373deic_e_s
dekes105224453d_eke_s
detickers1634423detickers
deys85027473d___eys
diadems1135393diadems
dialers83614303dialers
diapers104713913diapers
dibbers124013173dibbers
dicasts1078703dicasts
dice75841893dic_e__
diced95824683dic_e_d
dicer85426423dic_e_r
dicier94416233dicie_r
diciest103316523diciest
dick116432383dick___
dickenses1645073dickenses
dickered16117533dickered
dickhead1944143dickhead
dickheads2043633dickheads
dickie133913113dick_ie
dickier143512453dickier
dickiest153412503dickiest
dicking153617613dicking
dicots94915793dic_ots
dicotyl1344403dicotyl
dicotyls1444183dicotyls
dictums1235553dictums
dicty115116293dic_ty_
diddleys14334633diddleys
didies84621833didie_s
didoes85716963didoe_s
dienes75719903diene_s
dies55653523di__e_s
diesels8429143diesels
dieses75218693diese_s
dieters83216433dieters
diets66026643di__ets
differs14339973differs
diggers104413393diggers
digress938323digress
dike95935763di_ke__
diked115024683di_ke_d
diker105524553di_ke_r
dimers94321093di_mers
dimes85833043di_me_s
dimmers123811563dimmers
dimness1038843dimness
diners75525953di_ners
dines66449153di_ne_s
dingers94321383dingers
dinges83825423dinge_s
dingey114914053dingey_
dinked124818353dinke_d
dinkies123716033dinkies
dinkly144311083dinkly_
dinks105927953dink__s
dinkums1433673dinkums
dinky135819373dink_y_
dinners83915443dinners
diodes83915783diode_s
dipnets10109033dipnets
dippers123615183dippers
dirges84915103dirge_s
dirked124912273dirke_d
dirks105619523dirk__s
dishes104622653dishe_s
disked125015763diske_d
disks105417473disk__s
dismays13237433dismays
dismes95617673disme_s
disobeys1443683disobeys
dispels10310503dispels
disses75225963disse_s
ditchers143610363ditchers
ditches133215713ditche_s
dites66339153di_te_s
dithers114016153dithers
ditzes163212423ditze_s
divers105024963di_vers
dives95832403di_ve_s
dizens164911393di_zens
docked145018333docke_d
docker134417653docke_r
docket134721173docke_t
docks126022313dock__s
dogeys115510663d_ogeys
donkey14449733donkey_
doohickeys2310903doohickeys
dovekeys1941723dovekeys
doyleys14384923doyleys
drakes114715863drake_s
drinkers13277823drinkers
duces86327473duc_e_s
duchess1335553duchess
ducked144718013ducke_d
ducker134317993ducke_r
duckies143613813duckies
ducks124823213duck__s
ducky154216113duck_y_
duikers12369383duikers
dukes105023473d_uke_s
dunkers123512193dunkers
dykes135215573d_yke_s
dykey16608673d_ykey_
fices106031163fic_e_s
fiches145219533fiche_s
fickly18318533fickly_
ficoes114613463ficoe_s
flickers17338883flickers
fuckers163611593fuckers
hackees165014103hackees
hackers164619043hackers
hackneys2033683hackneys
hawkeys20414703hawkeys
hickies163614743hickies
hicks145322173hick__s
hikers135014353hi_kers
hikes125426983hi_ke_s
hockers163915913hockers
hockey184813153hockey_
honkeys17439513honkeys
hookeys17448953hookeys
hunkeys17386193hunkeys
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
shickers173012823shickers
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_
thickens17266413thickens
thickets17287083thickets
ticked134720523ticke_d
ticker124321503ticke_r
ticket124524853ticke_t
ticklers14339303ticklers
tickles133416853tickles
ticks115823293tick__s
tikes95628903ti_ke_s
tinkers113517143tinkers
trickers143812813trickers
tuckers134014353tuckers
tuckets134810333tuckets
turkeys1434523turkeys
vices105725533vic_e_s
wackes154717713wacke_s
whickers20297983whickers
whiskeys21353383whiskeys
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.420425454.8
2DLD Change Limit1340273606.08022043.9
3Display Results3603600.1232926.8
 (SQL Overall)1786913606.62326980.4
 
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.