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

402 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
hickie15381247(None) 
dickie133913111dickie
hackie154615621hackie
hickies163614741hickies
sickie123715741sickie
bikie113915882bi_kie
birkie124110132birkie
chickee183111552chickee
dickier143512452dickier
dickies143416342dickies
duckie133511662duckie
fickle153912972fickle
hackee154921832hackee
hackies163418242hackies
hackle154916812hackle
hankie133915712hankie
hawkie163810092hawkie
heckle153112092heckle
hick135530302hick__
hickey185011992hickey
hickish1936472hickish
hicks145322172hick_s
hike116830392hi_k_e
hinkier143610792hinkier
hippie132811242hippie
honkie133011662honkie
huckle153913072huckle
hunkie133812382hunkie
ickier12439912_ickier
kickier12349052kickier
luckie123611412luckie
mickle143715132mickle
nickle123814482nickle
pickier153912972pickier
pickle144215652pickle
pinkie124414272pinkie
quickie2235512quickie
sickee124622222sickee
sickies133717502sickies
sickle124418322sickle
silkie103313402silkie
tickle124616742tickle
trickie132611032trickie
ackee115825363_ackee
alkie95520033_alkie
bhistie1236763bhistie
bice86235553bic__e
bicker144819173bicker
biggie103810933biggie
bike106532593bi_k_e
bikies124515163bi_kies
billie85019173billie
birdie94013783birdie
birkies133712433birkies
boccie123311453boccie
bookie123516003bookie
brickier16307163brickier
brickle15279933brickle
buckle144815193buckle
cackle143416923cackle
chicane1489553chicane
chichi1637093chichi_
chichier1836023chichier
chichis1737073chichis
chick165419133chick__
chickees19258513chickees
chicken18278983chicken
chickpea2143193chickpea
chicks175317593chick_s
chicle134312543chic_le
chinkier17377363chinkier
chippie16297693chippie
chuckies1937703chuckies
chuckle1836443chuckle
cicale10314503cicale
civie103716353ci_vie
cockier154013623cockier
cockle143913573cockle
cookie123716043cookie
darkie113714013darkie
deckle1312012453deckle
dice75841893dic__e
dicier94416233dic_ier
dick116432383dick__
dicked144920863dicked
dicker134521403dicker
dickey165913523dickey
dickiest153412503dickiest
dicking153617613dicking
dicks125824693dick_s
dicky154816243dick_y
dictier103411863dictier
didie74120563di_die
dike95935763di_k_e
dinkier123411503dinkier
dinkies123716033dinkies
duckier143911793duckier
duckies143613813duckies
fice95737113fic__e
fiche134616743fic_he
ficin103516723fic_in
fickler16348423fickler
fickly18318533fickly
fictile1238023fictile
fictive1537023fictive
firkin1337823firkin
folkie13369613folkie
ghillie11326353ghillie
gillie74816943gillie
gimmie11298173gimmie
girlie73711463girlie
hack135134543hack__
hacked164923513hacked
hackees165014103hackees
hacker154822693hacker
hacking173720613hacking
hackled173312483hackled
hackler163512353hackler
hackles162917063hackles
hacklier1737133hacklier
hackly18298733hackly
hackmen1836713hackmen
hackney1935123hackney
hacks144928713hack_s
hake115637843h_ak_e
hakim14311823h_akim
hankies143617763hankies
hawkies173311243hawkies
heck135826493heck__
heckled17318463heckled
heckler16278573heckler
heckles163711383heckles
hecks145220653heck_s
hectic132311513hectic
heinie92512663heinie
hempie132410563hempie
hic86540563hic___
hiccup1554393hiccup
hickeys19508223hickeys
hickories1845313hickories
hickory1943903hickory
hide85134623hi__de
hie67652703h___ie
higgle113811743higgle
hiked135919203hi_ked
hiker125119393hi_ker
hikes125426983hi_kes
hiking143617103hi_king
hili75626633hi_li_
hillier103413963hillier
hinge95323443hi_nge
hinkiest153311753hinkiest
hinky155618753hink_y
hinnied11348103hinnied
hinnies103615103hinnies
hiplike1637603hiplike
hipline12311423hipline
hippier143212103hippier
hippies142813743hippies
hircine1239143hircine
hire75538963hi__re
hiree85427803hi_ree
hirple11158973hirple
hirsle9159573hirsle
hispid1238173hispid
hissier103410503hissier
hissies103915823hissies
hive106029673hi__ve
hoagie102310003hoagie
hock136031303hock__
hocked165521303hocked
hocker155118563hocker
hockey184813153hockey
hocking173417243hocking
hocks144925493hock_s
hogtie102711763hogtie
hoick145210683hoick__
hoicked1735963hoicked
hoicking1836053hoicking
hoicks15378283hoick_s
hoke115935933h_ok_e
hokier134214033h_okier
homie104622523h_omie
honkies143015143honkies
hoochie1537783hoochie
hoodie105116133hoodie
hookier143811673hookier
hookies144017443hookies
hoolie93217773hoolie
hottie92514363hottie
howdie13349723howdie
huck135927633huck__
huckles163612623huckles
hucks144322173huck_s
hulkier14328973hulkier
hunkier144512143hunkier
hunkies143214503hunkies
huskier14369753huskier
huskies143212073huskies
ice56737243_ic__e
icier74313743_ic_ier
ick97329323_ick__
icker114018443_icker
ickiest133611043_ickiest
ickily1535743_ickily
icky136315753_ick_y
ictic9311793_ictic
indie63721463_indie
inkier104013773_inkier
inkle94515833_inkle
jackies202912623jackies
jimmie17376463jimmie
junkie17339603junkie
keckle11359423keckle
kick96026063kick__
kicked124415943kicked
kicker114116183kicker
kickiest13319673kickiest
kicking133314023kicking
kicks104420083kick_s
kickup1354133kickup
kicky135012333kick_y
kiddie12359393kiddie
kike76524783ki_k_e
killie104114893killie
kiltie103210963kiltie
kinkier10319433kinkier
kookie9389833kookie
lice66045063lic__e
lichee114017973lichee
lichi104412953lichi_
lichis115212593lichis
licit74327683lic_it
lick106935073lick__
licked134621563licked
licker125222043licker
licking144118283licking
licks115325393lick_s
like86040843li_k_e
luckier133811533luckier
luckies133313683luckies
mackle143716433mackle
mice87442223mic__e
miche126219243mic_he
mick126333423mick__
mickey174211853mickey
mickler153310233mickler
mickles153415003mickles
micks135525373mick_s
mike105535283mi_k_e
milkier133411163milkier
minke115421763mink_e
mirkier13319053mirkier
mislie83219153mislie
muckier153411473muckier
muckle143413583muckle
muskie123412533muskie
necktie1344363necktie
nice65534713nic__e
niche105016793nic_he
nick106627603nick__
nicked135019683nicked
nickel123811343nickel
nicker123818703nicker
nicking143516323nicking
nickled144010443nickled
nickles133713823nickles
nicks114920493nick_s
nicoise937923nicoise
nitchie1247233nitchie
nixie125114943ni_xie
nookie103712433nookie
peckier153910523peckier
pice84641093pic__e
pick125933813pick__
pickax2135913pickax
pickaxe2244623pickaxe
picked154421313picked
pickeer153710113pickeer
picker144422173picker
picket144924313picket
pickiest162712593pickiest
picking163418333picking
pickled164011883pickled
pickles153215443pickles
picks135226143pick_s
pickup1655633pickup
picky165416943pick_y
picnic123410263picnic
picric12309923picric
picrite111911313picrite
piggie103210773piggie
pike106335213pi_k_e
piki106520563pi_ki_
pikis115116393pi_kis
pinkies133818263pinkies
pipkin14248603pipkin
pixie145415523pi_xie
pliskie1394543pliskie
pockier153911603pockier
prickier16368143prickier
prickle153611013prickle
punkie123513613punkie
quickies2336773quickies
rackle123917293rackle
rice64942913ric__e
ricin74620213ric_in
rick107334653rick__
ricked136523623ricked
rickey154613973rickey
ricking143920233ricking
ricks115126133rick_s
riskier1138423riskier
rockier134911883rockier
rookie103613263rookie
ruckle124414583ruckle
selkie102811693selkie
shackle16409543shackle
shicker163914823shicker
shicksa1634103shicksa
shikse1386073shi_kse
shtickier1843163shtickier
sice65545593sic__e
sick106435573sick__
sickbed16396823sickbed
sicked134524403sicked
sickees134514213sickees
sicken124615253sicken
sicker124023903sicker
sicking143720173sicking
sickish1638423sickish
sickled144713433sickled
sickles133417543sickles
sicklied1546583sicklied
sicklier1457213sicklier
sicklies14710013sicklies
sickly153110483sickly
sicko115315393sick_o
sickos125112033sickos
sicks115127623sick_s
sike87138783si_k_e
silkier114411643silkier
silkies113715693silkies
siskin1079783siskin
stickier14229763stickier
stickies142211973stickies
stickit1339463stickit
stickle132410973stickle
suckier133613973suckier
suckle124015963suckle
tackier133712523tackier
tackle123815733tackle
talkie103914443talkie
techie11511723techie
tekkie934203tekkie
thick145613353thick__
thicken16317873thicken
thicker163611023thicker
thicket163213073thicket
thickish2044593thickish
thickly19415573thickly
thicks154511993thick_s
thickset17257133thickset
tick106231223tick__
ticked134720523ticked
ticker124321503ticker
ticket124524853ticket
ticking143218753ticking
tickled144313133tickled
tickler133612653tickler
tickles133416853tickles
ticks115823293tick_s
tike85534483ti_k_e
tiki87620843ti_ki_
tikis95615973ti_kis
tinkle103714453tinkle
tittie63213153tittie
trickier143010233trickier
trickle133613443trickle
twinkie1434563twinkie
vice95732853vic__e
vichies15310623vichies
victim1337683victim
wacke145918623wack_e
wackier16369733wackier
whackier2044673whackier
whicker19359773whicker
whiskies1835953whiskies
wick135726303wick__
wickape1843723wickape
wicked164317413wicked
wicker154518673wicker
wicket155318943wicket
wicking173414773wicking
wickiup18172673wickiup
wicks144619363wick_s
widdie113410733widdie
wienie9229973wienie
willie94116453willie
winkle133812833winkle
yippie13277843yippie
yuckier16358533yuckier

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 Filter1786911127160.1431249587.4
2DLD Change Limit1127164027.07615929.3
3Display Results4024020.2661511.3
 (SQL Overall)1786914027.48523873.2
 
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.