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

104 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
ferneries123904(None) 
beaneries11310902beaneries
deaneries10310832deaneries
ferries103521082fer__ries
fineries112416742f_ineries
flaneries1249562flaneries
forgeries13310002forgeries
henneries1248642henneries
merceries13410042merceries
ternaries9311642ternaries
turneries948492turneries
veneries112815032ve_neries
wernerites1344942wernerites
arteries8321483_arteries
berberines1445633berberines
berberins1346713berberins
berberis1246603berberi_s
berberises1444903berberises
bergeres1189113berger_es
berries94423553ber__ries
breweries1447583breweries
canneries11313083canneries
celeries10316313ce_leries
derries83124623der__ries
eateries8324313_eateries
emeries91620023_e_meries
emperies12314563_emperies
enemies9313693_e_nemies
energies9310783_e_nergies
entries71523163_e_ntries
faeries104118993f__aeries
fakeries1559833f_akeries
farnesses122310813farnesses
farrieries1344343farrieries
felonries1246203felonries
feodaries1346373feodaries
feretories1348603feretories
ferities111416713fer_ities
ferlies103216693fer__lies
fernery1335813ferner__y
fernier103110823fern__ier
ferniest1132214153fern__iest
ferried113411523fer__ried
ferrites112312833fer__rites
fervencies1845183fervencies
feudaries1345883feudaries
fewnesses1534953fewnesses
feynesses1535223feynesses
fisheries1548643fisheries
flanerie1146913flanerie_
fooleries1248743fooleries
fopperies1666013fopperies
foundries1345693foundries
freebies1337873f_reebies
frenetics1444603frenetics
frenzies2037713fren_zies
freres94716173f_r_er_es
friaries11310083f_riaries
fulleries1248723fulleries
furmeties1446573furmeties
furrieries1343943furrieries
generics11118793ge_nerics
gentries91315263ge_ntries
greeneries1167073greeneries
gunneries1047043gunneries
helleries122611683helleries
henries102718283he_n_ries
heresies11312693her_esies
heronries1248483heronries
herries104025073her__ries
jerries143817513jer__ries
joineries1648103joineries
kerries113317913ker__ries
lecheries1449073lecheries
mercerise1356413mercerise
mercerises1446193mercerises
mercerizes2346053mercerizes
mercuries1347273mercuries
nunneries947113nunneries
nurseries948013nurseries
ornerier846043_ornerier
orneriest947403_orneriest
orreries8310123_orreries
pedleries1298783pedleries
peeries93623023pe__eries
penuries10311663pe_nuries
perjuries1846493perjuries
perries93226603per__ries
pineries102419083_pineries
reentries9311763reentries
refineries1347063refineries
reveries112518513re_veries
sceneries1149393sceneries
sealeries9313133sealeries
sentries81318053se_ntries
serries73925353ser__ries
sorceries1149933sorceries
surgeries10311363surgeries
tanneries9310423tanneries
terries73425633ter__ries
veeries102916893ve__eries
vineries112716043_vineries
wernerite1245173wernerite
wineries112316533_wineries

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411047.17320722.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.64223382.8
 
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.