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

383 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
rickeys1654898(None) 
dickeys17479301dickeys
hickeys19508221hickeys
mickeys18447941mickeys
rickets134915091rickets
rickey154613971rickey_
bickers154316552bickers
crickets16418122crickets
crickey18418142crickey_
dickens144410132dickens
dickers144117662dickers
dickey165913522dickey_
dinkeys15507262dinkeys
hickey185011992hickey_
hockeys19509272hockeys
ickers123914182_ickers
jockeys23365952jockeys
kickers124013292kickers
lackeys16458262lackeys
lickers134118252lickers
mickey174211852mickey_
nickels13338652nickels
nickers134415092nickers
pickers153718092pickers
pickets154314182pickets
pinkeys16378212pinkeys
prickers163710672prickers
prickets16329082prickets
rackers134320452rackers
rackets134916872rackets
rekeys13347692r_ekeys
ricers84120992ric_ers
rices75536152ric_e_s
richens12349732richens
riches115022082riche_s
ricked136523622ricke_d
rickety16478312rickety
ricks115126132rick__s
ridleys11145782ridleys
riskers114011992riskers
rockers133916552rockers
rockets134615362rockets
sickees134514212sickees
sickens134411482sickens
tickers133617722tickers
tickets134113682tickets
trickers143812812trickers
wickers164114702wickers
wickets164010942wickets
ackees124914583_ackees
backers153821893backers
beckets15399823beckets
biceps12447713bic_eps
bices95029963bic_e_s
bicker144819173bicke_r
bikers124517553bi_kers
bikes117529473bi_ke_s
bilkers134711863bilkers
brackens16327923brackens
brackets163310433brackets
bricked164312063bricke_d
brickles162810283brickles
bricks144614623brick__s
bricky17489093brick_y_
briskets14346563briskets
brockets16328123brockets
buckers153517453buckers
buckets153811693buckets
buckeye1835683buckeye
buckeyes1945263buckeyes
chickees19258513chickees
chickens19267433chickens
clickers163910203clickers
cockers153618333cockers
cockeye1867223cockeye
cockeyes1967033cockeyes
cockneys1934493cockneys
cookeys16478503cookeys
crackers164111723crackers
cricked164814283cricke_d
cricket154716953cricke_t
cricks144316053crick__s
crikey15317783cri_key_
crockets16339543crockets
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
drinkers13277823drinkers
duckers143214713duckers
fices106031163fic_e_s
fiches145219533fiche_s
fickly18318533fickly_
ficoes114613463ficoe_s
flickers17338883flickers
friskers15337373friskers
friskets15326263friskets
fuckers163611593fuckers
hackees165014103hackees
hackers164619043hackers
hackneys2033683hackneys
hawkeys20414703hawkeys
hickies163614743hickies
hicks145322173hick__s
hikers135014353hi_kers
hikes125426983hi_ke_s
hockers163915913hockers
hockey184813153hockey_
honkeys17439513honkeys
hookeys17448963hookeys
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
pricers113915063pric_ers
prices104524543pric_e_s
pricey134412633pric_ey_
pricked164613833pricke_d
pricker154013413pricke_r
pricket153616443pricke_t
prickles162511093prickles
prickly18367893prickly_
pricks144414263prick__s
pricky174210343prick_y_
prinkers143010383prinkers
puckers153514673puckers
punkeys16366493punkeys
quickens2334253quickens
racers84725433rac_ers
races74943243rac_e_s
rachets124516833rachets
racked134526083racke_d
racker124824553racke_r
racket125229423racke_t
rackety16499113rackety
racks115028853rack__s
rakees104516973r_akees
rakers104123573r_akers
rakes94440353r_ake_s
rankers113217463rankers
recces10614913recce_s
recess8314263rec_ess
rechews1537293rechews
recked134821803recke_d
reckless14257973reckless
reckons13269653reckons
recks115625133reck__s
reekers113613143reekers
rekey124014733r_ekey_
ribbers113913183ribbers
ribes75530173ri_be_s
ribiers9319753ribiers
ribless93410343ribless
riblets93412553riblets
rice64942913ric_e__
riced85825543ric_e_d
ricer74726613ric_e_r
richen113812513riche_n
richer114015043riche_r
richest122813683richest
richly1438013richly_
richness1337433richness
ricins83618703ric_ins
ricinus9408123ricinus
rick107334653rick___
ricking143920233ricking
ricksha1643133ricksha
rickshas1743853rickshas
ricracs1136363ricracs
rictus8379193ric_tus
ridders93612493ridders
riders74123903ri_ders
rides66140813ri_de_s
ridgels9348023ridgels
ridges85817013ridge_s
ridley10169543ridley_
riels55121333ri__els
rievers104311453rievers
riflers103512193riflers
rifles94217703rifle_s
riggers93613843riggers
riles55343643ri_le_s
riley84420583ri_ley_
rilles64725503rille_s
rillets74216153rillets
rimers84522553ri_mers
rimes75634543ri_me_s
rimless9369363rimless
rimmers113812883rimmers
ringers83922953ringers
rinks94827103rink__s
rinsers73815743rinsers
rinses64720383rinse_s
rioters73615523rioters
ripens85012173ri_pens
ripes75435773ri_pe_s
rippers114115033rippers
risers64624783ri_sers
rises55244043ri_se_s
risked115514633riske_d
risker105414493riske_r
riskless1235763riskless
risks94917063risk__s
risky126311523risk_y_
rites54442553ri_te_s
ritters74020623ritters
ritzes154812943ritze_s
rivers94626543ri_vers
rives85336003ri_ve_s
rivets94417113ri_vets
rochets124213473rochets
rocked135022323rocke_d
rocker124319573rocke_r
rockery16439253rockery
rocket125425283rocke_t
rockless14297293rockless
rocks114626413rock__s
rocky144513853rock_y_
ruches114819583ruche_s
rucked134718763rucke_d
ruckles133414603ruckles
rucks114422053ruck__s
ruckus12407793ruck_us
rykes125513033r_yke_s
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
trackers143512853trackers
triceps11267343tric_eps
trices84826333tric_e_s
tricked144016163tricke_d
tricker134615523tricke_r
trickery17297343trickery
trickles143013763trickles
trickly16369893trickly_
tricks125319013trick__s
tricksy16436583tricksy_
tricky154211473trick_y_
trikes105419493tri_ke_s
trinkets1237143trinkets
truckers14279013truckers
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
wreckers17315973wreckers
wricked174910193wricke_d
wricks154610623wrick__s
yikes125117753yi_ke_s

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 Limit1340273836.50020619.5
3Display Results3833830.1402735.7
 (SQL Overall)1786913837.04625360.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.