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 “gene” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

310 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
gene5623722(None) 
agene65621581agene
bene66439491bene
dene56643411dene
gane55145301gane
gee45359201ge_e
gen45950511gen_
genes65133091genes
genet66038681genet
genie66124921genie
genre66016801genre
gens55740071gens
gent56954391gent
genu55929071genu
gone55639041gone
nene45932061nene
sene46848051sene
acne66625872acne
agee56241492age_e
agenes74720252agenes
agent65829642agent
agone65924552agone
akene95818662akene
ane37866952_ane
arene55329412arene
bane65250432bane
bee56262402be_e
been65335782been
ben56554922ben_
bend76435262bend
benes75536232benes
benne76521122benne
bens65945702bens
bent67759912bent
bine66650872bine
bone65949322bone
cane66653122cane
cede74928782cede
cee55952702ce_e
cense75121402cense
cent67451012cent
cepe84926652cepe
cere66741472cere
cete64934782cete
cine66242952cine
cone67256962cone
dee47665822de_e
deke95228762deke
dele56843082dele
deme76536282deme
den47554342den_
denes65639722denes
deni56929392deni
dens55945072dens
dense65923502dense
dent57158412dent
deny86027122deny
dere56845902dere
diene65720132diene
dine55555342dine
done55747912done
dune56137582dune
dyne85320932dyne
eke75630092_eke
eme55837182_eme
en28052392_en_
end46834362_end
eng46726782_eng
ens37245922_ens
ere36352772_ere
erne46727432erne
esne47018792esne
eve66331162_eve
ewe66630982_ewe
eye65539772_eye
eyne76322462eyne
fane75343572fane
fee66862012fe_e
feme96130542feme
fen66851352fen_
fence105319912fence
fend84832972fend
fens76139762fens
fere76342232fere
fete75734922fete
fine75147962fine
gae46457702g_ae
gaen57329602gaen_
gage65936102gage
gale56347322gale
game76644322game
gan48060132gan_
ganef96322462ganef
ganev95513862ganev
gang66031982gang
gape75134512gape
gate55746572gate
gave84634052gave
gaze145032412gaze
gear55934972gear
geck115721992geck
ged57044542ge_d
geds66730822geds
geed65435502geed
geek95327022geek
gees55647882gees
geese64316002geese
geez146424862geez
gel45642432ge_l
geld65828432geld
gelee63626982gelee
gels56836102gels
gelt56448012gelt
gem66840222ge_m
gems75329112gems
gender83517932gender
genera71211712genera
genets75716662genets
geneva1085852geneva
genic85119392genic
genies75324942genies
genii64514172genii
genip84415202genip
genoa64315822genoa
genom83716842genom
genome94312192genome
genres75515622genres
genro64914032genro
gentes75324162gentes
gentle74014512gentle
gents65729612gents
genua64614152genua
genus65319832genus
geode7412592geode
germ75428962germ
gest56149132gest
geste65920692geste
get47467462ge_t
geta56627442geta
gets55442482gets
geum75424552geum
gey75738302ge_y
ghee85726112ghee
gibe75927792gibe
gie47149552g_ie
gien56330032gien_
gin46055762gin_
gink97129532gink
gins55543962gins
gite55438622gite
give85829362give
glebe85016442glebe
glede75517832glede
glee55239062glee
glen56027202glen_
glens66519852glens
glue55628492glue
gnu45522042g_nu
gonef95221292gonef
goner66025162goner
gong66827192gong
gore55744962gore
grebe85114942grebe
gree56641562gree
green65522142green
grue55825712grue
gude65423342gude
gun47240802gun_
gunk95423572gunk
guns55533482guns
gwine95513662gwine
gybe105916242gybe
gyre84722762gyre
gyrene10227242gyrene
gyve116215082gyve
hebe96424702hebe
heme95034412heme
hen67555272hen_
hence104920052hence
henge94819832henge
hens75642572hens
hent76656382hent
here76447102here
hone77549322hone
jane115031482jane
jee106648642je_e
jefe146516882jefe
jete115927252jete
kane85133982kane
keen84830422keen
ken76344002ken_
keno87926452keno
kens85435252kens
kent86846982kent
kente95821072kente
kerne94718222kerne
kine85643442kine
knee85323612knee
kune85424582kune
lane45153332lane
lee36068142le_e
leke85527402leke
lend56233672lend
lenes54738522lenes
leno47331392leno
lens46146492lens
lense54523432lense
lent46360532lent
leone55018822leone
line46965582line
lone45849132lone
lune47140492lune
mane65052032mane
meme85330552meme
men59252852men_
mend75334032mend
meno66031362meno
mense75025632mense
menu65130232menu
mere67244442mere
mesne75116292mesne
mete64438132mete
meze154420902meze
mine67256182mine
ne27045102__ne
nee36657782ne_e
nenes55329672nenes
neve76224832neve
nine45842182nine
none45743172none
ogee57629882oge_e
one37050912_one
pane64950292pane
pee56066512pe_e
peen65938082peen
peke105926202peke
pele65539552pele
pen56558842pen_
pence94924452pence
pend75934532pend
penes75839222penes
penne75423852penne
pens65649642pens
pent66559072pent
pere66450262pere
pine67755722pine
pone65747532pone
rede55037682rede
ree37974072re_e
rend56136572rend
renew83917512renew
rent46661242rent
rente54733782rente
rete44944132rete
rune45236302rune
sane45954342sane
scene77220572scene
see35772262se_e
seen46943122seen
seine55732872seine
seme65836652seme
sen36058522sen_
send55237292send
sense55526822sense
sent46963012sent
sente56432882sente
sere46153472sere
sine46560632sine
skene96118122skene
sone46649982sone
syne75725762syne
tee38366872te_e
teen45938202teen
tele45040872tele
ten35856112ten_
tend56433772tend
tenet55542212tenet
tenge65720452tenge
tens45647412tens
tense55225842tense
tent46159862tent
terne56426152terne
tine45855142tine
tone46953742tone
tune45635862tune
tyne76325052tyne
vane75534692vane
vee65750182ve_e
vena76126292vena
venae85920982venae
vend86626422vend
venge95117992venge
vent76049052vent
venue84918212venue
vine75643692vine
wane76344722wane
wee66760812we_e
ween75835462ween
wen66249602wen_
wend85330452wend
wens76337932wens
went76051872went
were76238332were
wine74953432wine
yen66847382yen_
yens75832262yens
yente86220042yente
zee126143232ze_e
zine137036162zine
zone135231082zone

Search took 3 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 Filter178691298720.296603685.8
2DLD Change Limit298723101.67317855.3
3Display Results3103100.0764078.9
 (SQL Overall)1786913102.04587379.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.