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

160 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
generic10131075(None) 
generics11118791generics
genetic101211781genetic
agenetic1138202agenetic
benefic1446042benefic
bigeneric1443592bigeneric
centric11312402centric
dineric10310972dineric
enteric9314212_enteric
genera71211712gener_a
general81010932general
generical1246992generical
genesis82510822genesis
genetics11128612genetics
genic85119392gen__ic
genomic1237922genomic
gentrice1148812gentrice
gesneria944052gesneria
gynecic1584352gynecic
acentric1247533acentric
aetheric13410163aetheric
agenesia945983agenesia
agenesis938043agenesis
amnesic1137183amnesic
anemic102713693_anemic
anergic1048103_anergic
anuric8812103_anuric
apneic1078623apne_ic
benedick1743093benedick
benedict1346423benedict
benefice1545003benefice
benefit1248073benefit
benthic1437473benthic
benzoic2045033benzoic
celeriac1246163celeriac
cerebric1444633cerebric
ceric94023093__ceric
cinerin9313823cinerin
cleric10612133_cleric
congeneric1554673congeneric
demerit10314993demerit
denari710917353denari_
denarii8389123denarii
desertic1147743desertic
deuteric1146343deuteric
digenetic1345353digenetic
dimeric12310013dimeric
ecesic10369223_ecesic
edenic9310223_edenic
eerie55228533_e_erie
emetic10614453_emetic
enatic8317563_enatic
endemic1237893_endemic
endermic1356173_endermic
endrin7312403_endrin
energid948303_energid
energy10137513_energy
enolic8413353_enolic
enrich1138943_en_rich
enterics10312853_enterics
epeiric1145313_epeiric
etheric12311783etheric
ferric1139993fe_rric
flueric1246143flueric
frenetic1346293frenetic
galenic1038693galenic
gametic1239993gametic
gastric1038633gastric
gender83517933gender__
gendered11258873gendered
gendering12249753gendering
genderize2065673genderize
genders93616783gender_s
gene56237223gene___
generalcy1543423generalcy
generals9109333generals
generate9312903generate
generous939773generous
genes65133093gene__s
geneses82613523geneses
genet66038683gene__t
genetical1247573genetical
genets75716663gene_ts
genette838863genette
geneva1085853gene_va
genevas1185253genevas
genie66124923gen__ie
genii64514173gen__ii
genip84415203gen__ip
genomics1345713genomics
genre66016803gen_r_e
genres75515623gen_res
genro64914033gen_r_o
genros74211333gen_ros
gentil74115123gen_til
gentrices1258913gentrices
gentries91315263gentries
gentrify1544683gentrify
gentry103410443gentr_y
geodesic1243563geodesic
geodetic1246323geodetic
geodic1048003ge_odic
geometric14158313geometric
georgic1144293georgic
gesneriad1142323gesneriad
gestic9312773ge_stic
glyceric1643933glyceric
gnomic11248593g_nomic
gomeril1047383gomeril
gonadic1177213gonadic
goner66025163goner__
goners74420173goner_s
gonidic1166103gonidic
gynecia1384233gynecia
hebetic1438633hebetic
heretic12314833heretic
hetaeric1346763hetaeric
homeric14312213homeric
icteric1138023icteric
kenotic1359713kenotic
kinesic13257023kinesic
kinetic13209173kinetic
lentic83515743len_tic
lexemic1844283lexemic
mantric11311343mantric
mesmeric1445813mesmeric
meteoric1247303meteoric
metric10314673me_tric
naric76824173__naric
neoteric1047853neoteric
nephric1446213nephric
numeric1158193numeric
oneiric945613oneiric
oogenetic1255493oogenetic
peerie83617893pe_erie
peloric11310713peloric
phenetic1549203phenetic
reverie103615163reverie
selenic9410663selenic
sememic1336503sememic
senarii7269143senarii
senecio947203senecio
spheric14510073spheric
steric8317063_steric
suberic11312213suberic
synergic1444313synergic
tantric939583tantric
tendril836783tendril
tenesmic1244303tenesmic
tenrec837513ten_rec
terebic1137983terebic
tonemic11310173tonemic
tonetic9313433tonetic
ureteric1046233ureteric
valeric1238303valeric
venatic12311523venatic
veneries112815033veneries
venery123710663vener_y
xenic144114643xen__ic
xeric144315663__xeric

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 Limit1340271607.56317721.4
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.76623009.4
 
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.