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

449 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
tickler13361265(None) 
fickler16348421fickler
mickler153310231mickler
stickler14259571stickler
tackler134013321tackler
ticker124321501tick_er
tickle124616741tickle_
tickled144313131tickled
ticklers14339301ticklers
tickles133416851tickles
tinkler113610541tinkler
bicker144819172bick_er
buckler154112032buckler
cackler153812572cackler
dicker134521402dick_er
dickier143512452dickier
fickle153912972fickle_
hackler163512352hackler
heckler16278572heckler
icker114018442_ick_er
ickier12439922_ickier
kicker114116182kick_er
kickier12349052kickier
licker125222042lick_er
mickle143715132mickle_
mickles153415002mickles
nicker123818702nick_er
nickle123814482nickle_
nickled144010442nickled
nickles133713822nickles
pickeer153710112pickeer
picker144422172pick_er
pickier153912972pickier
pickle144215652pickle_
pickled164011882pickled
pickles153215442pickles
sicker124023902sick_er
sickle124418322sickle_
sickled144713432sickled
sickles133417542sickles
sicklier1457212sicklier
sticker133515882stick_er
stickier14229762stickier
stickle132410972stickle_
stickled15298972stickled
sticklers15227392sticklers
stickles142512102stickles
suckler133413092suckler
tacker124224502tack_er
tackier133712522tackier
tackle123815732tackle_
tackled143913192tackled
tacklers143010772tacklers
tackles133816522tackles
thicker163611022thick_er
ticked134720522tick_ed
tickers133617722tick_ers
ticket124524852tick_et
tiddler93110002tiddler
tiler56131022ti__ler
tiller64222542ti_ller
tingler83613342tingler
tinker103619922tink_er
tinkle103714452tinkle_
tinkled123910472tinkled
tinklers12298182tinklers
tinkles113713922tinkles
tinklier1255442tinklier
tippler11348342tippler
tricker134615522trick_er
trickier143010232trickier
trickle133613442trickle_
trickled152610432trickled
trickles143013762trickles
tricklier15256822tricklier
truckler14297452truckler
tucker124316952tuck_er
twinkler1564072twinkler
wicker154518672wick_er
backer144525523back_er
bickerer16106773bickerer
bickers154316553bick_ers
bicolor1145613bicolor
bicycler1742693bicycler
biker116022563bi_k_er
bilker124913443bilk_er
biller84923483bi_ller
birler85715083bi_rler
brickier16307163brickier
brickle15279933brickle_
brickles162810283brickles
bucker145420463buck_er
buckle144815193buckle_
buckled164411883buckled
bucklers16349503bucklers
buckles153416093buckles
cackle143416923cackle_
cackled164613303cackled
cacklers163710703cacklers
cackles153717203cackles
chuckler1935553chuckler
cicale10314503cicale_
circler1136423circler
clicker154111883click_er
cocker144320393cock_er
cockier154013623cockier
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
cycler1335913cyc_ler
dacker134920753dack_er
decker135215993deck_er
deckle1312012453deckle_
deckles143312803deckles
deticker1545283detick_er
dialer74315433di_aler
dialler848813dialler
dibbler124510283dibbler
dicer85426423dic__er
dicier94416233dic_ier
dicked144920863dick_ed
dickers144117663dick_ers
dickey165913523dick_ey
dickie133913113dickie_
dickies143416343dickies
dictier103411863dictier
diddler103511513diddler
diker105524553di_k_er
dinkier123411503dinkier
docker134417653dock_er
ducker134317993duck_er
duckier143911793duckier
ficklest17267903ficklest
fickly18318533fickl_y
fiddler12309953fiddler
filer85433003fi__ler
filler94623623fi_ller
flicker163610623flick_er
fucker153414423fuck_er
giggler101029883giggler
giller74519733gi_ller
girdler9227313girdler
hacker154822693hack_er
hackle154916813hackle_
hackled173312493hackled
hacklers173710303hacklers
hackles162917063hackles
hacklier1737133hacklier
heckle153112093heckle_
heckled17318463heckled
hecklers17357123hecklers
heckles163711383heckles
hickey185011993hick_ey
hickie153812473hickie_
hickies163614743hickies
higgler12369803higgler
hiker125119393hi_k_er
hiller94421633hi_ller
hinkier143610793hinkier
hocker155118563hock_er
huckle153913073huckle_
huckles163612623huckles
icier74313753_ic_ier
ickers123914183_ick_ers
idler65015663_i_dler
iller54821293_i_ller
inker94421093_ink_er
inkier104013783_inkier
inkle94515833_inkle_
inkles103515653_inkles
itchier12247673itchier
jacker194417583jack_er
jackleg2135043jackleg
jingler154311093jingler
jinker174013543jink_er
keckle11359423keckle_
keckled13376503keckled
keckles12318763keckles
kicked124415943kick_ed
kickers124013293kick_ers
killer104917953ki_ller
kindler12309983kindler
kinkier10319433kinkier
kittler11338163kittler
knuckler1383623knuckler
lacker125325623lack_er
libeler9219003libeler
licked134621563lick_ed
lickers134118253lick_ers
liker95627063li_k_er
linker104321473link_er
littler7348553littler
locker124019423lock_er
luckier133811533luckier
mackle143716433mackle_
mackled164111923mackled
mackles154415753mackles
mickey174211853mick_ey
micklest16219123micklest
middler112712273middler
miler75733063mi__ler
milker124814323milk_er
milkier133411163milkier
miller84625413mi_ller
mingler104213843mingler
mirker123712693mirk_er
mirkier13319053mirkier
mocker143315443mock_er
mucker143816393muck_er
muckier153411483muckier
muckle143413583muckle_
muckles153413253muckles
necker124012793neck_er
nibbler11379273nibbler
nicer74618293nic__er
nicked135019683nick_ed
nickel123811343nick_el
nickeled15115513nickeled
nickels13338653nickels
nickers134415093nick_ers
niggler93610293niggler
nimbler11358063nimbler
ocker113915753_ock_er
oiler54628283oi__ler
packer144223403pack_er
pecker144615363peck_er
peckier153910523peckier
picked154421313pick_ed
pickeers16347243pickeers
pickers153718093pick_ers
picket144924313pick_et
picketer16187433picketer
piddler112911523piddler
piker115622843pi_k_er
pinker125322443pink_er
pockier153911603pockier
pricker154013413prick_er
prickier16368143prickier
prickle153611013prickle_
prickled17358073prickled
prickles162511093prickles
pricklier17245063pricklier
pucker143817633puck_er
quicker2247023quick_er
racker124824553rack_er
rackle123917293rackle_
ricer74726613ric__er
richer114015043ric_her
ricked136523623rick_ed
rickey154613973rick_ey
riddler93411263riddler
riffler13328353riffler
rifler94014263ri_fler
rippler113210103rippler
risker105414493risk_er
riskier1138423riskier
rocker124319573rock_er
rockier134911883rockier
ruckle124414583ruckle_
ruckled144111033ruckled
ruckles133414603ruckles
sacker125124843sack_er
scaler84321603_scaler
shackler17317973shackler
shicker163914823shick_er
shtickier1843163shtickier
sickbed16396823sickbed
sicked134524403sick_ed
sickee124622223sick_ee
sickees134514213sickees
sicken124615253sick_en
sickener1436603sickener
sickie123715743sickie_
sickies133717503sickies
sicklied1546583sicklied
sicklies14710013sicklies
sickly153110483sickl_y
sidler74716963si_dler
siker95326033si_k_er
silkier114411643silkier
siller64026063si_ller
simpler112910863simpler
sinker103620903sink_er
sizzler15266863sizzler
slicker133314533slick_er
snicker133012673snick_er
stacker134416263stack_er
sticked144114633stick_ed
stickers142913033stick_ers
stickies142211973stickies
stickmen1634543stickmen
stifler102911473sti_fler
stiller73414303sti_ller
stinker113313313stink_er
stinkier12278543stinkier
stippler1235543stippler
stocker133713083stock_er
stockier14217253stockier
strickle1467793strickle_
strickled1665833strickled
strickles1567813strickles
sucker124120663suck_er
suckier133613973suckier
suckle124015963suckle_
suckled144212513suckled
sucklers14379963sucklers
suckles134516743suckles
tacked134723943tack_ed
tackers134319623tack_ers
tacket124627493tack_et
tackey154613083tack_ey
tackless14419483tackless
tailer63823733t_ailer
taker95229003t_ak_er
taler56034863t__aler
talker103916223talk_er
talkier114011843talkier
taller63721963t_aller
tangler83515073tangler
tanker104521123tank_er
tattler73112213tattler
techier1269243techier
teller63519823t_eller
thaler94613103t_haler
thicken16317873thick_en
thickener1844163thickener
thicket163213073thick_et
thickly19415573thickl_y
thickset17257133thickset
thinker143610683think_er
tical76021493tical__
ticals83214713tical_s
ticced11438443tic_ced
tick106231223tick___
ticketed15146643ticketed
tickets134113683tickets
ticking143218753ticking
tickling15309433tickling
ticklish1755283ticklish
ticks115823293tick__s
tickseed1584513tickseed
tiddlers10288653tiddlers
tidier73515113ti_dier
tier44936143ti___er
tiger65718633ti__ger
tighter112910693tighter
tike85534483ti_k_e_
tikes95628903ti_k_es
tile45451443ti__le_
tiled64832943ti__led
tilers63523503ti__lers
tiles55542103ti__les
tilled74722953ti_lled
tillers73418743ti_llers
tilter63417693ti_lter
timber104012683ti_mber
timelier1036713timelier
timer75626043ti__mer
timider1037093timider
tinder73821803ti_nder
tingle74319063tingle_
tingled93712803tingled
tinglers93710593tinglers
tingles83818323tingles
tinglier956403tinglier
tinier63622233ti_nier
tinkerer1286803tinkerer
tinkers113517143tink_ers
tinkly134811153tinkl_y
tinner64119963ti_nner
tinnier72910143tinnier
tinter63923643ti_nter
tipper103918413ti_pper
tippier113210543tippier
tipple103411913tipple_
tippled12358393tippled
tipplers12336353tipplers
tipples112811253tipples
tipsier9268893tipsier
tipster9299053tipster
tireder837703tireder
tirled74714363ti_rled
titer55430613ti__ter
titfer9409523ti_tfer
tither94920283ti_ther
title54721073ti_tle_
titled73815003ti_tled
titles63719923ti_tles
titter63421163ti_tter
tittle63613323tittle_
tittles73413253tittles
titular737523titular
tocher114014913toc_her
toddler9379043toddler
toggler9399193toggler
toiler63918283t_oiler
toker95924913t_ok_er
toller63819443t_oller
tooler63818613t_ooler
tootler73511123tootler
tracker133515173track_er
trailer73015393trailer
trawler104011903trawler
trekker1034733trekker
tricked144016163trick_ed
trickers143812813trick_ers
trickery17297343trick_ery
trickie132611033trickie_
trickly16369893trickl_y
tricksier15275243tricksier
trickster15265703trickster
tricolor10115833tricolor
trifler103912153trifler
triller74215893triller
troller73913173troller
trucker134010733truck_er
truckle13358863truckle_
truckled15327313truckled
trucklers15295583trucklers
truckles14319383truckles
tucked134017493tuck_ed
tuckers134014353tuck_ers
tucket124219483tuck_et
tumbler113412823tumbler
tummler11266613tummler
turtler72610323turtler
tusker104212193tusk_er
twiddler13244873twiddler
twinkle1464773twinkle_
twinkled1663943twinkled
twinklers1633063twinklers
twinkles1535073twinkles
twirler10285203twirler
viler86324163vi__ler
wacker154920123wack_er
wackier16369733wackier
whicker19359773whick_er
wicked164317413wick_ed
wickeder1843983wickeder
wickers164114703wick_ers
wicket155318943wick_et
wickless1736083wickless
wiggler123110763wiggler
willer94021063wi_ller
winker134220293wink_er
winkle133812833winkle_
winkled15299593winkled
winkles143412773winkles
yuckier16358533yuckier

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.390458182.1
2DLD Change Limit1340274495.86022871.5
3Display Results4494490.1562878.2
 (SQL Overall)1786914496.40627894.3
 
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.