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

416 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
fickler1634842(None) 
fickle153912971fickle_
mickler153310231mickler
tickler133612651tickler
bicker144819172bick_er
buckler154112032buckler
cackler153812572cackler
dicker134521402dick_er
dickier143512452dickier
ficklest17267902ficklest
fickly18318532fickl_y
fiddler12309952fiddler
filer85433002fi__ler
filler94623622fi_ller
flicker163610622flick_er
fucker153414422fuck_er
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
stickler14259572stickler
suckler133413092suckler
tackler134013322tackler
ticker124321502tick_er
tickle124616742tickle_
tickled144313132tickled
ticklers14339302ticklers
tickles133416852tickles
tinkler113610542tinkler
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_
cackled164613293cackled
cacklers163710703cacklers
cackles153717203cackles
chuckler1935553chuckler
cicale10314503cicale_
circler1136423circler
clicker154111883click_er
cocker144320393cock_er
cockier154013623cockier
cockle143913573cockle_
cockled163710823cockled
cockles153414643cockles
cycler1335913cyc_ler
dacker134920753dack_er
decker135215993deck_er
deckle1312012453deckle_
deckles143312803deckles
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
fabler116115813f_abler
facer105525053fac__er
facile112514883facile_
facular122810443facular
fakeer13378743f_akeer
faker124824593f_ak_er
faller94621233f_aller
feckless17225783feckless
feckly18335963feckl_y
feebler1235823feebler
feeler93215173f_eeler
feller94419553f_eller
fibber134811933fi_bber
fiber104921133fi__ber
fibster12146533fibster
fibular12267973fibular
fice95737113fic__e_
fices106031163fic__es
fiche134616743fic_he_
fiches145219533fic_hes
ficoes114613463fic_oes
fictile1238023fictile_
ficuses12159203ficuses
fiddle113613383fiddle_
fiddled13329633fiddled
fiddlers13328283fiddlers
fiddles123212603fiddles
fielder11217413fielder
fiercer12356953fiercer
fierier103511193fierier
fifer115519973fi__fer
fighter143010773fighter
figurer11215863figurer
filar84819293fi__lar
filcher15377793filcher
file75446643fi__le_
filed95331903fi__led
filers94623723fi__lers
files85441273fi__les
filet85540163fi__let
fille84327403fi_lle_
filled104922263fi_lled
fillers104320213fi_llers
filles94224523fi_lles
fillet95027083fi_llet
filmer114112403fi_lmer
filmier1237503filmier
filter94517633fi_lter
fimble133611753fimble_
fimbles143510663fimbles
finagler12194953finagler
finale94116763finale_
finales104016013finales
finder104020233fi_nder
finer85431563fi__ner
finger104920333fi_nger
finickier1842623finickier
finked144214623fink_ed
finnier10319953finnier
fipple13329063fipple_
fipples14298653fipples
firer811229253fi__rer
firmer114712443fi_rmer
firrier103410133firrier
fisher124917143fi_sher
fishier13359853fishier
fitter94120033fi_tter
fiver116024943fi__ver
fixer154717833fi__xer
fizzer17369383fi_zzer
fizzier18326713fizzier
fizzle17369713fizzle_
fizzled19357273fizzled
fizzles18339063fizzles
flaker134916173flak_er
flakier143910203flakier
flichter1664963flichter
flicked174610673flick_ed
flickers17338883flick_ers
flickery20365103flick_ery
flockier1745343flockier
flukier14397853flukier
focuser12155783focuser
folkier14359043folkier
fondler11348883fondler
footler104011873footler
foozler19397593foozler
forker134717903fork_er
forkier144311593forkier
fouler93614903f_ouler
fowler123712583f_owler
frailer10319943frailer
freckle16106643freckle_
freckled18104443freckled
freckles17126383freckles
frecklier1842993frecklier
fribbler15265953fribbler
friller104111743friller
frisker14389273frisk_er
friskier1535193friskier
frivoler1443933frivoler
frizzler19345843frizzler
fucked164114483fuck_ed
fuckers163611593fuck_ers
fueler94313933f_ueler
fueller10279963fueller
fuller94220383f_uller
fumbler143610813fumbler
funker133915763funk_er
funkier14349983funkier
furler93616403f_urler
giggler101029883giggler
giller74519733gi_ller
girdler9227313girdler
hacker154822693hack_er
hackle154916813hackle_
hackled173312483hackled
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
jacker194417583jack_er
jackleg2135033jackleg
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_
mackled164111913mackled
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
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
sticker133515883stick_er
stickier14229763stickier
stickle132410973stickle_
stickled15298973stickled
sticklers15227393sticklers
stickles142512103stickles
sucker124120663suck_er
suckier133613973suckier
suckle124015963suckle_
suckled144212513suckled
sucklers14379963sucklers
suckles134516743suckles
tacker124224503tack_er
tackier133712523tackier
tackle123815733tackle_
tackled143913183tackled
tacklers143010773tacklers
tackles133816523tackles
thicker163611023thick_er
ticked134720523tick_ed
tickers133617723tick_ers
ticket124524853tick_et
tiddler93110003tiddler
tiler56131023ti__ler
tiller64222543ti_ller
tingler83613343tingler
tinker103619923tink_er
tinkle103714453tinkle_
tinkled123910473tinkled
tinklers12298183tinklers
tinkles113713923tinkles
tinklier1255443tinklier
tippler11348343tippler
tricker134615523trick_er
trickier143010233trickier
trickle133613443trickle_
trickled152610433trickled
trickles143013763trickles
tricklier15256823tricklier
truckler14297453truckler
tucker124316953tuck_er
twinkler1564073twinkler
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 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.1401276364.3
2DLD Change Limit1340274166.78019768.0
3Display Results4164160.1432909.1
 (SQL Overall)1786914167.06325299.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.