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

412 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
ferrels1024862(None) 
ferrel92810201ferrel_
ferrets103111391ferrets
barrels94514362barrels
carrels95117302carrels
fardels11389892fardels
farfels13348212farfels
fearers104815272fearers
feels85223042fe__els
fennels10387902fennels
ferals94216642fe_rals
feres86038182fe_re_s
ferreled1234842ferreled
ferreous1146042ferreous
ferret93021172ferre_t
ferrety13287012ferrety
ferries103521082ferries
ferrous1049802ferrous
ferrule1035862ferrule
ferrules1136162ferrules
ferrums1265982ferrums
ferules103112722ferules
freres94716172frere_s
kernels11417952kernels
parrels94713492parrels
petrels9279372petrels
sorrels7310722sorrels
tercels94110362tercels
terrets72913582terrets
aerials74017553aerials
aeries64737783aerie_s
aerogels945593aerogels
ariels65119373_ariels
artels66216233_artels
barbels114514433barbels
barrel84517883barrel_
barrens94414323barrens
barres84427553barre_s
barrets94917103barrets
bearers94619593bearers
bedels94015273be_dels
befrets1237613befrets
berets85822523be_rets
bermes106023003berme_s
berries94423553berries
beryls11107883be_ryls
betels84515063be_tels
bethels1238533bethels
bevels113913983be_vels
bezels173712283be_zels
bordels103911973bordels
burrers93814493burrers
carcels114516063carcels
carpels115315463carpels
carrel84718633carrel_
carrell94610473carrell
carrells10359273carrells
cartels94618123cartels
carvels124914593carvels
ceorls848163ceor_ls
cereals9313173cereals
ceres75540013ce_re_s
cereus85215523ce_reus
cermets1139713cermets
certes84623083certe_s
cervelas1344673cervelas
corbels113813593corbels
cormels113813373cormels
cornels94716663cornels
corrals93713853corrals
creels84416943_creels
crenels93711013crenels
crewels12438493crewels
darnels83710433darnels
deckels14367363deckels
decrees102513123decrees
deferrals1343683deferrals
deferrers13115153deferrers
defuels11296983defuels
degrees92810723degrees
depress10239873depress
derails84216393derails
derries83124623derries
derris73615273derr_is
devels104313903de_vels
dorsels84412583dorsels
earls56127513_ear_ls
easels65914553_easels
eels46536743_e__els
egress73310433_egress
egrets72712243_egrets
enrols61213383_enrols
ernes55224813_erne_s
erred65915673_erre_d
errors63311313_errors
errs45622533_err__s
erses55826803_erse_s
ervils948773_ervils
excels1536663_excels
expels1547173_expels
eyres84921773_eyre_s
faeries104118993faerie_s
farcers124713443farcers
farces115223323farce_s
fardel104712593fardel_
farers95924053f_arers
fares85852873f_are_s
farfals13268503farfals
farfel124310433farfel_
farles96025783farle_s
farls85731113f_ar_ls
farmers124315263farmers
farness102912203farness
farriers113610743farriers
farrows13259793farrows
feared106320433feare_d
fearer94820183feare_r
fearless1137873fearless
fears84829393fear__s
feases95422923fease_s
feazes184514173feaze_s
febrile1237153febrile
feces105625363fe_ce_s
fecials123510333fecials
federals1247303federals
feebs106112683fe__ebs
feeders113712863feeders
feeds94921143fe__eds
feel75233843fe__el_
feelers103814743feelers
feeless103511103feeless
fees76450603fe__e_s
feezes184412613feeze_s
felafels1452853felafels
fellers104117543fellers
fells85327383fe__lls
females12310663females
femes105626223fe_me_s
femmes135410213femme_s
fencers123810623fencers
fences114617113fence_s
fenders113717263fenders
fennecs12305693fennecs
fennel9429473fennel_
feral85424653fe_ral_
ferbams1435743ferbams
fere76342233fe_re__
ferial94621253ferial_
ferias95020393fe_rias
ferlies103216693ferlies
ferly115517353fe_r_ly
ferment12315573ferment
ferments13311473ferments
fermis114313503fe_rmis
fernery1335813fernery
fernless1136063fernless
ferns85220083fe_r_ns
ferrate103014043ferrate
ferrates113013423ferrates
ferreling13136273ferreling
ferrelled1343943ferrelled
ferreted1236333ferreted
ferreter1136543ferreter
ferreters1246253ferreters
ferric1139993ferr_ic
ferried113411533ferried
ferrite103312753ferrite
ferrites112312833ferrites
ferruled1263923ferruled
ferrum1147453ferr_um
ferry116020803ferr__y
fertile10311733fertile
ferula93011173fe_rula
ferulas103110753ferulas
ferule93413203fe_rule
feruled11318423feruled
fervent13310063fervent
fervors1336233fervors
fesses94820253fesse_s
festers104121393festers
fetes85630143fe_te_s
fetials103711743fetials
fetters103517903fetters
fettles103912733fettles
fevers125414893fe_vers
fewness1335003fewness
fewtrils1443203fewtrils
feyness1334923feyness
fezes175220023fe_ze_s
fezzes174910403fezze_s
fibres114312123fibre_s
fibrils1236843fibrils
fiercely1643323fiercely
firers94922683f_irers
fires85740753f_ire_s
firmers124711443firmers
flares94521703flare_s
florals104210063florals
florets1039853florets
forceps14466983forceps
forcers124215713forcers
forces114422133force_s
fores85847103f_ore_s
forgers115218183forgers
forges105024263forge_s
forgets113813793forgets
forkers144615783forkers
formals123312893formals
formers128217953formers
formes114623713forme_s
formols12299413formols
formyls15235703formyls
fortes95327183forte_s
fortress1136753fortress
frails93716473f_rails
freely12310963f_reely
freers94717303f_reers
frees86131393f__rees
frere85617723frere__
fresnels1135233fresnels
frets85523403f__rets
friers94718933f_riers
fries85535603f_rie_s
frills94414223f_rills
froes86126693f_roe_s
fryers125710973f_ryers
fuehrers1442613fuehrers
fuels87117353f__uels
fuhrers1334813fuhrers
funnels10348173funnels
furies95126373furie_s
furlers104214223furlers
furless103210143furless
furls85322053f_ur_ls
furores10310033furore_s
furred104514433furre_d
furriers11369493furriers
furrily1337613furrily
furrows13327793furrows
furzes186613693furze_s
fusels94412453f_usels
garrets84413623garrets
genres75515623genre_s
gerbils1037303gerbils
germens1078633germens
gruels73910153_gruels
hearers104319783hearers
heels85625533he__els
heiress1036813heiress
herbals122710613herbals
herders113914123herders
heres86245903he_re_s
herls85226433he_r_ls
heroes94923833heroe_s
herpes115517323herpe_s
herries104025083herries
herself1337623herself
hirsels10128353hirsels
inferrers12226583inferrers
jebels15418913je_bels
jeerers14328923jeerers
jereeds15326393jereeds
jerkers18287083jerkers
jerreed1535213jerreed
jerreeds1653273jerreeds
jerrids15277743jerrids
jerries143817513jerries
jerseys1733243jerseys
jewels16508613je_wels
jurels133710583_jurels
keels94622413ke__els
kennels11387193kennels
kermes124616133kerme_s
kermess13396223kermess
kernel104010593kernel_
kernes104717533kerne_s
kerrias11289513kerrias
kerries113317913kerries
kerseys1433993kerseys
kestrels1235813kestrels
kevels134410713ke_vels
laurels746663laurels
levels94113283le_vels
marcels113212373marcels
marrers93414313marrers
marvels123810093marvels
mercers114412773mercers
merces105720743merce_s
merdes94518603merde_s
merely111312593me_rely
meres75143573me_re_s
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
merles85322763merle_s
merls77423903me_r_ls
merrily1238633merrily
metres85121563metre_s
morels84820023_morels
morsels94112663morsels
murres85019043murre_s
murreys12367323murreys
nereis6315343ne_reis
nerols6914893ne_rols
nerves94216193nerve_s
newels93710823ne_wels
oriels64914623_oriels
parcels113712663parcels
parrals94414573parrals
parrel84515983parrel_
pearls84715393pear_ls
peels75226423pe__els
peeress939503peeress
pencels113610063pencels
peres76246643pe_re_s
perils84121853pe_rils
perries93226603perries
perrons93115483perrons
perses85428063perse_s
petrel83111533petrel_
petrols92913083petrols
peytrels1363373peytrels
pyrrols1235403pyrrols
quarrels1735083quarrels
rearers74323563rearers
rebels84518133re_bels
redress82511873redress
reels55333263__reels
refeels10379693refeels
refels94618053re_fels
referrals1243503referrals
referrers12125373referrers
refuels10399523refuels
regress82711453regress
regrets83212923regrets
reheels10298253reheels
repels84318763re_pels
repress92712683repress
rerolls739943rerolls
revels94220573re_vels
riels55121333__riels
saurels749303saurels
secrets9311773secrets
seels55632823se__els
seeress7311573seeress
seidels838393seidels
sequels1665713sequels
serails73318363serails
seres55448893se_re_s
sergers83815633sergers
serges74225973serge_s
serials73919753serials
series64540973serie_s
serries73925353serries
servals103410753servals
servers103214833servers
serves94423653serve_s
sirrees73410573sirrees
sorels63921163_sorels
sorrel6413553sorrel_
streels73811343streels
surreys10489443surreys
tarres64723043tarre_s
tearers75218233tearers
teasels74311313teasels
teazels16406893teazels
teels55726373te__els
tenrecs936033tenrecs
tercel83612993tercel_
terces83921413terce_s
tercets93512443tercets
termers95414503termers
ternes65422903terne_s
terras63516973terr_as
terreen7257573terreen
terreens8246533terreens
terrella844703terrella
terrellas944293terrellas
terrene72411033terrene
terrenes82212603terrenes
terret63425623terre_t
terriers84210823terriers
terries73425633terries
territs72714503territs
terrors73112213terrors
tersely1038113tersely
tetryls1034643tetryls
thermels13607763thermels
tiercels10344743tiercels
turrets73010673turrets
unreels7258313unreels
verbals121910743verbals
vergers114412633vergers
verges104320183verge_s
vermeils1374813vermeils
vermes115019143verme_s
versers103813523versers
verses94223763verse_s
versets103913103versets
verves124617883verve_s
vervets13419753vervets
vessels1035933vessels
warrens103810893warrens
wearers104615903wearers
weasels10468503weasels
wedels103811033we_dels
wergeld1233183wergeld
wergelds1342293wergelds
wergelt1138583wergelt
wergelts1253413wergelts
wurzels1934083wurzels
zeroes154314343zeroe_s

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.406440125.6
2DLD Change Limit1340274126.26621389.6
3Display Results4124120.1562641.0
 (SQL Overall)1786914126.82826170.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.