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

131 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
genetics1112861(None) 
generics11118791generics
genetic101211781genetic_
agenetic1138202agenetic_
emetics11610722_emetics
frenetics1444602frenetics
generic101310752generic_
genesis82510822genesi_s
genetical1247572genetical
geneticist1356702geneticist
genets75716662genet__s
genettes938302genettes
genomics1345712genomics
geodetics1344462geodetics
heretics13310502heretics
kinetics14207252kinetics
memetics1447802memetics
phenetics1646482phenetics
tonetics1048942tonetics
agenesias1045363agenesias
agenesis938043agenesi_s
amnesics1255283amnesics
antics84621453_an_tics
ascetics1247073ascetics
auxetics1744763auxetics
benedick1743093benedick
benedicks1842563benedicks
benedict1346423benedict
benedicts1443573benedicts
benefic1446043benefic_
benefice1545003benefice
benefices1645063benefices
benefits1345713benefits
cretics112911653_cretics
deictics1345563deictics
demotics1338753demotics
dentils84115583den_tils
dentins83419223den_tins
dietetics1244693dietetics
digenetic1345353digenetic_
emetic10614453_emetic_
emetins9812643_emetins
enatic8317563_enatic_
endemics1346273_endemics
enemies9313693_enemies
enterics10312853_enterics
entice81316863_en_tice
entices91616333_en_tices
enuretics1145063_enuretics
erotics91914153_erotics
exegetics1943573exegetics
exotics16229193_exotics
fanatics1367183fanatics
frenetic1346293frenetic_
gaieties9310183gaieties
gametic1239993gametic_
gayeties1236883gayeties
gelatins93414093gelatins
gelatis83313513gelati_s
generals9109333generals
generical1246993generical
generous939773generous
genes65133093gene___s
geneses82613523gene_ses
genet66038683genet___
geneticists1454383geneticists
genette838863genet_te
genevas1185253gene_vas
genic85119393gen__ic_
genies75324943gen__ies
genips9469943gen__ips
genitals937243genitals
genitive1247643genitive
genitives1346663genitives
genitors937423genitors
genius74512923gen__ius
genomic1237923genomic_
gentes75324163gen_t_es
gentian8310103gen_tian
gentians937563gen_tians
gentil74115123gen_ti_l
gentile83515293gen_tile
gentiles93713523gen_tiles
gentles83714343gen_tles
gentoos838633gen_toos
gentrice1148813gentrice
gentrices1258913gentrices
gentries91315263gentries
gents65729613gen_t__s
geodesics1342843geodesics
geodetic1246323geodetic_
geometrics15127083geometrics
georgics1242873georgics
gestic9312773ge_stic_
glyptics1643103glyptics
gneiss765953g_ne_iss
gnostics1146323gnostics
godetias1045343godetias
gynecic1584353gynecic_
hebetic1438633hebetic_
hematics151712193hematics
hepatics15198933hepatics
heretic12314833heretic_
kenotic1359713kenotic_
kinesics14286283kinesics
kinetic13209173kinetic_
kinetins12228153kinetins
lenities8315943lenities
lentic83515743len_tic_
lentils73912973len_tils
luetics937323_luetics
lunatics1045473lunatics
magnetics1447163magnetics
nineties8312913nineties
oogenetic1255493oogenetic_
paretics122312443paretics
peptics132610243pe_ptics
phenetic1549203phenetic_
phonetics1646733phonetics
poetics11312073_poetics
senecios1046303senecios
septics112810433se_ptics
splenetics1443413splenetics
tabetics1245683tabetics
telestics1196963telestics
tenets65518953tenet__s
tonetic9313433tonetic_
venatic12311523venatic_
veneries112815033veneries
venetian1146073venetian
venetians1244673venetians

Search took 9 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.406440125.6
2DLD Change Limit1461621317.53319402.9
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.98522378.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.