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

215 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
rickety1647831(None) 
rackety16499111rackety
rickets134915091rickets
rickey154613971ricke_y
cricket154716952cricket_
crickets16418122crickets
crickey18418142cricke_y
dickey165913522dicke_y
hickey185011992hicke_y
mickey174211852micke_y
nicety1138432nic_ety
picket144924312picket_
pickets154314182pickets
pricket153616442pricket_
prickets16329082prickets
racket125229422racket_
rackets134916872rackets
ricked136523622ricke_d
rickeys16548982rickeys
rockery16439252rockery
rocket125425282rocket_
rocketry1744502rocketry
rockets134615362rockets
thickety20274102thickety
ticket124524852ticket_
tickets134113682tickets
trickery17297342trickery
wicket155318942wicket_
wickets164010942wickets
becket144619883becket_
beckets15399823beckets
bicker144819173bicke_r
bickers154316553bickers
biggety1434433biggety
bracket154117233bracket_
brackets163310433brackets
bricked164312063bricke_d
bricky17489093brick__y
brisket134413403brisket_
briskets14346563briskets
brocket154013383brocket_
brockets16328123brockets
bucket144620733bucket_
buckets153811693buckets
cicely1338833cic_ely
cricked164814283cricke_d
cricketed1854683cricketed
cricketer1744563cricketer
crikey15317783cri_ke_y
crockery19356603crockery
crocket154615673crocket_
crockets16339543crockets
dicey114819333dic_e_y
dicked144920863dicke_d
dickens144410133dickens
dicker134521403dicke_r
dickers144117663dickers
dickeys17479303dickeys
dicky154816243dick__y
dicty115116293dic__ty
dikey135116423di_ke_y
dinkey144812763dinke_y
docket134721173docket_
dockets144412243dockets
fickly18318533fick_ly
fidgety15384893fidgety
flickery20365103flickery
frisket143811773frisket_
friskets15326263friskets
hickeys19508223hickeys
hickory1943903hickory
hockey184813153hocke_y
icker114018443_icke_r
ickers123914183_ickers
ickily1535753_ickily
icky136315753_ick__y
jacket194720673jacket_
jackets205011373jackets
jockey22408033jocke_y
kicked124415943kicke_d
kicker114116183kicke_r
kickers124013293kickers
kicky135012333kick__y
lackey154813353lacke_y
licked134621563licke_d
licker125222043licke_r
lickers134118253lickers
likely13328133li_kely
locket123922473locket_
lockets134612203lockets
mickeys18447943mickeys
mockery18376913mockery
nicely1139493nic_ely
nicked135019683nicke_d
nickel123811343nicke_l
nickels13338653nickels
nicker123818703nicke_r
nickers134415093nickers
nimiety1244633nimiety
ninety9510963ni_nety
packet144726503packet_
packets155114773packets
pernickety2151693pernickety
picked154421313picke_d
pickeer153710113pickeer
picker144422173picke_r
pickers153718093pickers
picketed17167383picketed
picketer16187433picketer
picky165416943pick__y
piety105817303pi__ety
pinkey154314673pinke_y
pocket144622623pocket_
pockets154612253pockets
pricey134412633pric_e_y
pricked164613833pricke_d
pricker154013413pricke_r
prickers163710673prickers
prickly18367893prick_ly
pricky174210343prick__y
puckery18306263puckery
rachet115028973rachet_
rachets124516833rachets
racked134526083racke_d
racker124824553racke_r
rackers134320453rackers
racketed15169123racketed
recked134821803recke_d
rekey124014733r_eke_y
riblet84222443riblet_
riblets93412553riblets
rice64942913ric_e__
riced85825543ric_e_d
ricer74726613ric_e_r
ricers84120993ric_ers
rices75536153ric_e_s
richen113812513riche_n
richens12349733richens
richer114015043riche_r
riches115022083riche_s
richest122813683richest
richly1438003ric_hly
rick107334653rick___
ricketier15134583ricketier
ricking143920233ricking
ricks115126133rick__s
ricksha1643123ricksha
ricotta955433ricotta
ridley10169543ridle_y
rifely123710033ri_fely
riflery13345803riflery
righty135011833ri_ghty
riley84420583ri_le_y
rillet64828853rillet_
rillets74216153rillets
ripely112511153ri_pely
risked115514633riske_d
risker105414493riske_r
riskers114011993riskers
riskily1436413riskily
risky126311523risk__y
rivet85636363ri_vet_
rivets94417113ri_vets
rochet115423003rochet_
rochets124213473rochets
rockaby1843243rockaby
rocked135022323rocke_d
rocker124319573rocke_r
rockers133916553rockers
rocketed15157793rocketed
rocketer14158333rocketer
rocky144513853rock__y
rookery14398313rookery
rucked134718763rucke_d
russety1034613russety
sickbay1843723sickbay
sicked134524403sicke_d
sickee124622223sicke_e
sickees134514213sickees
sicken124615253sicke_n
sickens134411483sickens
sicker124023903sicke_r
sickerly1734023sickerly
sickest131813793sickest
sickly153110483sick_ly
snickery17295543snickery
society1236083society
socket123923523socket_
sockets134012983sockets
tacket124627493tacket_
tackets134914363tackets
tackey154613083tacke_y
thicket163213073thicket_
thickets17287083thickets
ticked134720523ticke_d
ticker124321503ticke_r
tickers133617723tickers
ticketed15146643ticketed
tricked144016163tricke_d
tricker134615523tricke_r
trickers143812813trickers
trickily1736233trickily
trickly16369893trick_ly
tricksy16436583trick_sy
tricky154211473trick__y
trinket11314813trinket_
trinketry1642803trinketry
trinkets1237143trinkets
tucket124219483tucket_
tuckets134810333tuckets
wicked164317413wicke_d
wickedly2142793wickedly
wicker154518673wicke_r
wickers164114703wickers
wricked174910193wricke_d

Search took 9 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 Limit1340272157.83017117.1
3Display Results2152150.0762828.9
 (SQL Overall)1786912158.06222164.6
 
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.