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

465 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
thicker16361102(None) 
shicker163914821shicker
thicken16317871thicken
thicket163213071thicket
thinker143610671thinker
ticker124321501t_icker
tricker134615521tricker
whicker19359771whicker
bicker144819172_bicker
checker18329532checker
chicer134513602chic_er
chickee183111552chickee
chicken18278982chicken
chirker16429322chirker
clicker154111882clicker
dicker134521402_dicker
flicker163610622flicker
hacker154822692_hacker
hickey185011992_hickey
hiker125119392_hi_ker
hocker155118562_hocker
icker114018442__icker
kicker114116182_kicker
licker125222042_licker
nicker123818702_nicker
picker144422172_picker
pricker154013412pricker
quicker2247022quicker
shickers173012822shickers
shikker13277022shikker
shirker143711342shirker
shocker163411422shocker
shucker163710102shucker
sicker124023902_sicker
slicker133314532slicker
snicker133012672snicker
sticker133515882sticker
tacker124224502t_acker
thacked173810202thacked
thanker14309592thanker
thick145613352thick__
thickener1844162thickener
thickens17266412thickens
thickest17337302thickest
thickets17287082thickets
thickety20274102thickety
thickly19415572thickly
thicks154511992thick_s
thickset17257132thickset
thinkers15308692thinkers
thinner10358962thinner
thither13328102thither
thwacker2042872thwacker
ticked134720522t_icked
tickers133617722t_ickers
ticket124524852t_icket
tickler133612652t_ickler
tinker103619922t_inker
tracker133515172tracker
tricked144016162tricked
trickers143812812trickers
trickery17297342trickery
trickier143010232trickier
trucker134010732trucker
tucker124316952t_ucker
whacker19368502whacker
whickers20297982whickers
whisker17367932whisker
wicker154518672_wicker
attacker14144983attacker
backer144525523_backer
bickers154316553_bickers
biker116022563_bi_ker
bilker124913443_bilker
blacker154513513blacker
blinker134110213blinker
blocker15419923blocker
bricked164312063bricked
brickier16307163brickier
brisker134210293brisker
bucker145420463_bucker
checked193710023checked
checkers19317843checkers
chicaner1586073chicaner
chichier1836023chichier
chick165419133chick__
chickees19258513chickees
chickens19267433chickens
chickory2243363chickory
chickpea2143193chickpea
chicks175317593chick_s
chicle134312543chicle_
chicles143512503chicles
chider125116053chi_der
chiefer1536863chiefer
chigger1436003chigger
chiller124112183chiller
chimer135517203chi_mer
chinked174011023chinked
chinkier17377363chinkier
chipper163912583chipper
chirked173810333chirked
chirper14359963chirper
chitter124112963chitter
chocked194411613chocked
choicer14197893choic_er
choker154314373ch_oker
chucked19469733chucked
chuckler1935553chuckler
chukker1543833chukker
clacker153813773clacker
clicked164112453clicked
clickers163910203clickers
clinker133811663clinker
clocker153910873clocker
cocker144320393_cocker
cracker153114173cracker
cricked164814283cricked
cricket154716953cricket
crickey18418143crickey
dacker134920753_dacker
daiker115113033dai_ker
decker135215993_decker
deicer94114413deic_er
deticker1545283deticker
dicer85426423_dic_er
dicier94416233_dicier
dicked144920863_dicked
dickers144117663_dickers
dickey165913523_dickey
dickier143512453_dickier
diker105524553_di_ker
docker134417653_docker
drinker12349473drinker
ducker134317993_ducker
duiker114110593dui_ker
fickler16348423_fickler
flicked174610673flicked
flickers17338883flickers
flickery20365103flickery
frisker14389273frisker
fucker153414423_fucker
hacked164923513_hacked
hackee154921833_hackee
hackers164619043_hackers
hackler163512353_hackler
hanker134622093_hanker
hawker164812663_hawker
heckler16278573_heckler
hick135530303_hick__
hickeys19508223_hickeys
hickie153812473_hickie
hickies163614743_hickies
hickory1943903_hickory
hicks145322173_hick_s
hider95024083_hi_der
higher134610893_higher
hijacker2442463_hijacker
hike116830393_hi_ke_
hiked135919203_hi_ked
hikers135014353_hi_kers
hikes125426983_hi_kes
hiller94421633_hiller
hinder104120063_hinder
hinger104723323_hinger
hinkier143610793_hinkier
hinter94021303_hinter
hipper133818023_hipper
hirer85423123_hi_rer
hisser94713793_hisser
hitcher153712003_hitcher
hither124417253_hither
hitter94419863_hitter
hocked165521303_hocked
hockers163915913_hockers
hockey184813153_hockey
hoicked1735963hoicked
honker134117463_honker
hooker134820173_hooker
hunker133917673_hunker
husker134212703_husker
icier74313753__icier
ickers123914183__ickers
ickier12439923__ickier
inker94421093__inker
jacker194417583_jacker
jinker174013543_jinker
juicer1536283juic_er
juicier1635463juicier
kicked124415943_kicked
kickers124013293_kickers
kickier12349053_kickier
knacker12307913knacker
knickers13306723knickers
knocker12296393knocker
lacker125325623_lacker
licked134621563_licked
lickers134118253_lickers
liker95627063_li_ker
linker104321473_linker
locker124019423_locker
mickey174211853_mickey
mickler153310233_mickler
milker124814323_milker
mimicker1843313mimicker
mirker123712693_mirker
mocker143315443_mocker
monicker1635733monicker
mucker143816393_mucker
necker124012793_necker
nicer74618293_nic_er
nicked135019683_nicked
nickel123811343_nickel
nickers134415093_nickers
nitpicker1742203nitpicker
ocker113915753__ocker
packer144223403_packer
pecker144615363_pecker
philter12108213philter
picked154421313_picked
pickeer153710113_pickeer
pickers153718093_pickers
picket144924313_picket
pickier153912973_pickier
piker115622843_pi_ker
pinker125322443_pinker
plinker134010963plinker
plucker15368243plucker
pricer103918293pric_er
pricier113313113pricier
pricked164613833pricked
prickers163710673prickers
pricket153616443pricket
prickier16368143prickier
prinker133412743prinker
pucker143817633_pucker
quicken2235153quicken
racker124824553_racker
rethinker1643613rethinker
ricer74726613_ric_er
richer114015043_richer
ricked136523623_ricked
rickey154613973_rickey
risker105414493_risker
rocker124319573_rocker
sacker125124843_sacker
shacked174015393shacked
shackler17317973shackler
shaker134319463sh_aker
sharker144313813sharker
shickered19115723shickered
shicksa1634103shicksa
shier85428943shi__er
shifter132911073shifter
shikar1336803shi_kar
shikkers14326523shikkers
shimmer143310873shimmer
shiner93820873shi_ner
shinier104113143shinier
shipper143514033shipper
shirked153710463shirked
shirkers15319583shirkers
shiver124517373shi_ver
shocked174611803shocked
shockers17319463shockers
shrieker15265653shrieker
shrinker15236363shrinker
shtickier1843163shtickier
shucked17389833shucked
shuckers17388133shuckers
sicked134524403_sicked
sickee124622223_sickee
sicken124615253_sicken
siker95326033_si_ker
sinker103620903_sinker
skinker10319443skinker
slacker133915293slacker
slicer84117603slic_er
slicked144413843slicked
slicken13309293slicken
slickers143112553slickers
smacker153410583smacker
smirker13327423smirker
snacker133112603snacker
snicked143811633snicked
snickers143010963snickers
snickery17295543snickery
spicer104719313spic_er
spicier115112463spicier
spiker124315663spi_ker
stacker134416263stacker
sticked144114633sticked
stickers142913023stickers
stickier14229763stickier
stickler14259573stickler
stinker113313313stinker
stocker133713083stocker
stricken1436893stricken
stricter1039413stricter
striker113714173stri_ker
sucker124120663_sucker
tacked134723943t_acked
tackers134319623t_ackers
tacket124627493t_acket
tackey154613083t_ackey
tackier133712523t_ackier
tackler134013323t_ackler
tailer63823733tai_ler
taker95229003t__aker
talcked1446343talcked
talker103916223t_alker
tanker104521123t_anker
teacher123714833teacher
thack144915173thack__
thacks154311923thack_s
thaler94613103th_aler
thanked15469153thanked
thankers15297833thankers
thatcher1635653thatcher
thawer12489343th_awer
theater104014253theater
thecae11299653thecae_
thewier1336063thewier
thickened1944303thickened
thickeners1943463thickeners
thicketed1943613thicketed
thickhead2242683thickhead
thickish2044593thickish
thickness1844443thickness
thicksets18263733thicksets
thief114516303thi__ef
thieve1235963thieve_
thieved1434973thieved
thievery1742563thievery
thieves1346903thieves
thighed1535263thighed
thine85026853thi_ne_
think125018793think__
thinks134613353think_s
thinned11399153thinned
thinners11327743thinners
thir76420543thi___r
thirled11328093thirled
thirster1135673thirster
thrice114311573thric_e_
thriller1165553thriller
thriver13479123thriver
thrower1386993thrower
thumper14356953thumper
thunder1136963thunder
thunked15386853thunked
thwacked2132723thwacked
thwackers2142223thwackers
thymier1534393thymier
ticced11438443t_icced
tick106231223t_ick__
tickets134113683t_ickets
tickle124616743t_ickle
tickled144313133t_ickled
ticklers14339303t_icklers
tickles133416853t_ickles
ticks115823293t_ick_s
tidier73515113t_idier
tier44936143t_i__er
tiger65718633t_i_ger
tike85534483t_i_ke_
tikes95628903t_i_kes
tiler56131023t_i_ler
tiller64222533t_iller
tilter63417693t_ilter
timber104012683t_imber
timer75626043t_i_mer
tinder73821803t_inder
tinier63622233t_inier
tinkers113517143t_inkers
tinkler113610543t_inkler
tinner64119963t_inner
tinter63923643t_inter
tipper103918413t_ipper
titer55430613t_i_ter
titfer9409523t_itfer
tither94920283t_ither
titter63421163t_itter
tocher114014913t_ocher
toiler63918283toi_ler
toker95924913t__oker
toucher124814353toucher
tracer84820233trac_er
tracked143716133tracked
trackers143512843trackers
trekker1034733trekker
trice75127493tric_e_
triced95518673tric_ed
tricep103911073tric_ep
trices84826333tric_es
trick115420693trick__
trickie132611033trickie
trickle133613443trickle
trickled152610433trickled
trickles143013763trickles
tricklier15256823tricklier
trickly16369893trickly
tricks125319013trick_s
tricksier15275243tricksier
trickster15265703trickster
tricksy16436583tricksy
tricky154211473trick_y
trier54328533tri__er
trifler103912153trifler
trigger9329163trigger
trike95320163tri_ke_
trikes105419493tri_kes
triller74215893triller
trimer85717153tri_mer
trimmer113610833trimmer
trinket11314813trinket
tripper113711923tripper
triter65120593tri_ter
trocked144312243trocked
trucked143910813trucked
truckers14279003truckers
truckler14297453truckler
tucked134017493t_ucked
tuckers134014353t_uckers
tucket124219483t_ucket
tusker104212193t_usker
twice104711123twic_e_
twier84713293twi__er
twiner94012593twi_ner
twinier1037313twinier
twinkler1564073twinkler
twirler10285203twirler
twister10308953twister
twitcher16135343twitcher
twitter10278093twitter
unsicker1435303unsicker
voicer113910543voic_er
wacker154920123_wacker
whacked20458623whacked
whackers20326543whackers
whackier2044673whackier
whickered22114033whickered
whiffer19105323whiffer
whimper17297723whimper
whiner124516633whi_ner
whinger1410810903whinger
whinier134110633whinier
whipper173611383whipper
whirler13307603whirler
whisked18336913whisked
whiskers18306773whiskers
whiskery21314553whiskery
whiskey20445583whiskey
whisper15298013whisper
whiter124316393whi_ter
whither163510253whither
whitier133311063whitier
whitter139110893whitter
whizzer2134583whizzer
wicked164317413_wicked
wickers164114703_wickers
wicket155318943_wicket
winker134220293_winker
wrecker16367603wrecker
wricked174910193wricked

Search took 10 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.1401276364.3
2DLD Change Limit1340274658.53015712.4
3Display Results4654650.3461343.9
 (SQL Overall)1786914659.01619819.3
 
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.