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

264 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
fennecs1230569(None) 
fennec11326911fennec_
fennels10387901fennels
bennes86019012benne_s
bennets94712162bennets
fanners103914652fanners
fencers123810622fencers
fences114617112fence_s
fenders113717262fenders
fennel9429472fenne_l
fewness1335002fewness
feyness1334922feyness
funnels10348172funnels
jennets14517632jennets
kennels11387192kennels
penners93414182penners
rennets75212632rennets
sennets73712582sennets
tenners74014922tenners
tenrecs936032tenrecs
aeneus61111143ae_neus
banners94018713banners
bannets94013843bannets
bendees103913863bendees
benders104021063benders
benes75536233be_ne_s
benne76521123benne__
bennet84823363benne_t
bennies93917313bennies
bennis84314803benn_is
bonnes85621453bonne_s
bonnets94812803bonnets
cannels93413363cannels
canners93822663canners
censers94313903censers
censes83721803cense_s
centers94420603centers
centners1057243centners
connect113515743connect
connects123010563connects
conners94023113conners
cunners93913473cunners
denes65639723de_ne_s
deniers84515183deniers
denies74729643denie_s
denned84215633denne_d
dinners83915443dinners
donnees84210363donnees
dunness8298983dunness
enders74324053_enders
ennead736253_ennead
enneads834733_enneads
ennuis636473_ennuis
enters64425643_enters
ernes55224813_erne_s
esnes54817363_esne_s
evenness1135543evenness
execs14539723_e_xecs
fanes84639893f_ane_s
fanfics1535173fanfics
fanjets1734803fanjets
fanned104117473fanne_d
fanner94218183fanne_r
fannies103415643fannies
farness102912203farness
fatness103311293fatness
fawners13388493fawners
fearers104815273fearers
feases95422923fease_s
feazes184514173feaze_s
feces105625363fe_ce_s
feebs106112683fe__ebs
feeders113712863feeders
feeds94921143fe__eds
feelers103814743feelers
feeless103511103feeless
feels85223043fe__els
fees76450603fe__e_s
feezes184412613feeze_s
feigners1235483feigners
feints94813873fein_ts
felines104718073feline_s
fellers104117543fellers
fellness1135913fellness
femes105626223fe_me_s
femmes135410213femme_s
fence105319913fe_n_ce
fenced124412713fence_d
fencer114613533fence_r
fended114216913fende_d
fender103718723fende_r
fends96324973fe_n_ds
fennier10339253fennier
fenniest113113203fenniest
fenny115115133fenn__y
fens76139763fe_n__s
feres86038183fe_re_s
fernery1335813fernery
fernless1136063fernless
ferns85220083fern__s
ferrels10248623ferrels
ferrets103111393ferrets
fesses94820253fesse_s
festers104121393festers
fetes85630143fe_te_s
fetters103517903fetters
fevers125414893fe_vers
fezes175220023fe_ze_s
fezzes174910403fezze_s
fiances12310673fiances
finances1338653finances
finders113717873finders
fineness11310643fineness
fines86644263f_ine_s
fingers113418433fingers
finless102810783finless
finned104114603finne_d
fitness10299393fitness
flanes94522423flane_s
flannels1134843flannels
flensers1135463flensers
flenses1039473flense_s
fondness1237213fondness
francs114112193fran_cs
freeness11710443freeness
fresnels1135233fresnels
fulness10248963fulness
funders113813933funders
funkers143712063funkers
funned103613953funne_d
funnel93610743funne_l
funner93414103funne_r
funnest102912003funnest
funnies104113603funnies
gannets83811443gannets
genders93616783genders
genes65133093ge_ne_s
genets75716663ge_nets
genies75324943genie_s
genres75515623genre_s
gentes75324163gente_s
ginners84314223ginners
gunnels8358563gunnels
gunners83111733gunners
henges104516463henge_s
henleys1334843henleys
hennas94211803henn_as
hennery1335303hennery
henpeck1843083henpeck
henpecks1942873henpecks
inners63919353_inners
jennet134714953jenne_t
jennies143511623jennies
keeners113610783keeners
keenness1234883keenness
kenned114411273kenne_d
kennel10369223kenne_l
kentes105118653kente_s
kernels11417953kernels
kernes104717533kerne_s
lanners73618333lanners
leaners73718173leaners
leanness837373leanness
lenders84419643lenders
lenes54738523le_ne_s
lenses64620893lense_s
leones64417723leone_s
linnets739833linnets
manners93417833manners
meaners94415243meaners
meanness1037183meanness
menaces112715523menaces
menders103818803menders
menses84222453mense_s
mentees93214503mentees
mesnes85216213mesne_s
nenes55329673ne_ne_s
newness1035703newness
nonnews1035313nonnews
oneness7512143oneness
openness1035473openness
panners93621273panners
pannes85522853panne_s
penances12312443penances
pencels113610053pencels
penes75839223pe_ne_s
penne75423853penne__
penned94217613penne_d
penner84616663penne_r
pennies94218813pennies
pennis84315743penn_is
pennons939713pennons
pensees9311203pensees
peones83821043peone_s
pfennigs1461983pfennigs
pinners93518603pinners
punners94114233punners
punnets9409263punnets
rebecs103913673re_becs
redneck1445113redneck
rednecks1544013rednecks
redness82012443redness
renders83821673renders
renews93811753re_news
rennet64624853renne_t
rennins74013413rennins
renters74224813renters
rentes65431193rente_s
ronnels7318613ronnels
runnels7329153runnels
runners74212453runners
seances93015343seances
seiners74219273seiners
seines65029903seine_s
senders83022353senders
seneca839793se_neca
senecas939013se_necas
sennas64214233senn_as
sennet64224143senne_t
sennits73811283sennits
senseis73310643senseis
senses63923943sense_s
sinners74019023sinners
sonnets74211993sonnets
tanners74018393tanners
tanrecs934823tanrecs
teeners74415453teeners
telnets738373telnets
tenaces92814513tenaces
tenders83719723tenders
tenets65518953te_nets
tenner64117103tenne_r
tennies73017973tennies
tennis64015303tenn_is
tenoners858713tenoners
tenrec837513tenrec_
tenses64722553tense_s
tenters73921103tenters
tenues63816443tenue_s
ternes65422903terne_s
tinners73717313tinners
tonners73816403tonners
tonnes65320853tonne_s
tunnels7328723tunnels
vanners103612843vanners
veiners104112523veiners
vendees114011453vendees
venders113717003venders
veneers103710293veneers
venenes102712133venenes
venges104015153venge_s
venines103516613venine_s
venters103717733venters
venues95115203venue_s
wanness102610683wanness
weaners104613833weaners
weiners103913063weiners
wetness10277723wetness
winners104316913winners
wonners104312813wonners
xebecs17355363xe_becs
yenned10409383yenne_d
yentes95517603yente_s
zebecs19316183ze_becs

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.453394461.4
2DLD Change Limit1340272646.20321606.8
3Display Results2642640.1102400.0
 (SQL Overall)1786912646.76626410.1
 
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.