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

105 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
generous93976(None) 
aeneous739892aene_ous
feverous1446512feverous
generals9109332generals
generics11118792generics
generously1445622generously
genros74211332gen_ro_s
onerous7312962_onerous
tenebrous1144182tenebrous
ungenerous1152782ungenerous
acerous9513333_acerous
aeneus61111143aene__us
anserous8410533anserous
anurous7311553_anurous
apterous10410463apterous
cancerous1367523cancerous
cankerous1566043cankerous
canorous10310193canorous
cerous85821203__cerous
cinderous1247033cinderous
cinereous1144983cinereous
congenerous1453593congenerous
dangerous1146093dangerous
decorous1138853decorous
denarius948813denarius
dendrons1047393dendrons
desirous947783desirous
dexterous1745553dexterous
dextrous1646593dextrous
dimerous1139323dimerous
dineros83812333dinero_s
emerods10137653_emerods
engross837123_engross
enormous1046553_enormous
enrols61213383_en_rols
enterons8314153_enterons
envious1037223_envious
estrous7712533_estrous
fencerows1742243fencerows
fenurons1174963fenurons
ferreous1146033ferreous
ferrous1049793fe_rrous
gaseous839503gase_ous
genders93616783gender__s
genera71211713gener__a
general81010933gener_al
generate9312893generate
generates10312703generates
generators1147533generators
generic101310753gener_ic
genes65133093gene___s
geneses82613523gene_ses
genesis82510823gene_sis
genetics11128613genetics
genets75716663gene__ts
genettes938303genettes
genevas1185253gene_vas
genitors937423genitors
genius74512923gen__ius
genoas74013623gen__oas
genoms94412483gen__oms
genres75515623gen_r_es
genro64914033gen_ro__
gentoos838633gen_toos
gentries91315263gentries
genus65319833gen___us
glabrous1145533glabrous
goitrous945763goitrous
goners74420163goner__s
grievous1243583grievous
heteros10312683hetero_s
igneous835773igne_ous
lecherous1445033lecherous
leprous938843le_prous
meandrous1245013meandrous
nerols6914883__nerols
nervous1037133__nervous
numerous1047833numerous
ocherous1346993ocherous
oestrous869903oestrous
penurious1145813penurious
petrous92714423pe_trous
ponderous1267263ponderous
revelrous1243893revelrous
rezeroes1737143rezeroes
rezeros1647453rezero_s
sclerous1047913sclerous
selenous848973selenous
senarius8310103senarius
sensuous845903sensuous
serous65023553__serous
sonorous8410403sonorous
suberous10311783suberous
tenebrious1252673tenebrious
tenesmus1043453tenesmus
tenuous738473ten_uous
tuberous1047483tuberous
ulcerous1046163ulcerous
veneries112815023veneries
venomous1345163venomous
venous93713193ven__ous
venturous1245583venturous
venulous1145713venulous
viperous1347613viperous
wondrous1246813wondrous

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621056.84321359.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.04525364.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.