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

171 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
geneva108585(None) 
genera71211711genera
genevas1185251genevas
enema7612742_enema
ganev95513862ganev_
ganevs10456912ganevs
gene56237222gene__
general81010932general
genes65133092gene_s
genet66038682gene_t
genets75716662genets
genoa64315822gen_oa
genua64614152gen_ua
seneca839792seneca
senega738172senega
adnexa1433673adnexa
aeneus61111143aeneus
agenda837253agen_da
agene65621583agene__
agenes74720253agene_s
agenesia945983agenesia
apnea73413413apne_a
bene66439493bene__
benes75536233bene_s
centra84113883centra
cinema1047643cinema
dene56643413dene__
denes65639723dene_s
deva85720983__deva
edema8610553_edema
enemas8812003_enemas
enemy1059993_enemy
entera64216833_entera
entia5318203_entia
envy10411253_en_vy
fanega1055783fanega
galea64722933gale_a
galena74911093galena
gane55145293gane__
ganef96322463gane_f
ganefs10489203ganefs
ganja131410003gan_ja
gee45359203ge_e__
geed65435503ge_e_d
geegaw1142853ge_egaw
geek95327023ge_e_k
geeks104915843ge_eks
geeky134710733ge_eky
gees55647883ge_e_s
geese64316003ge_ese
geest64829613ge_est
geez146424863ge_e_z
geisha1035193geisha
gelada837623gelada
gelee63626983gele_e
gelees74116263gelees
gemma106311773ge_mma
gen45950513gen___
gender83517933gender
genders93616783genders
generals9109333generals
generate9312893generate
generic101310753generic
geneses82613523geneses
genesis82510823genesis
genetic101211783genetic
genette838863genette
genial74917613genial
genic85119393gen_ic
genie66124923gen_ie
genies75324943genies
genii64514173gen_ii
genip84415203gen_ip
genipap1243123genipap
genips9469943genips
genital849793genital
genius74512923genius
genoas74013623genoas
genom83716843gen_om
genome94312193genome
genoms94412483genoms
genre66016803gen_re
genres75515623genres
genro64914033gen_ro
genros74211333genros
gens55740073gen__s
genseng933983genseng
gent56954393gen__t
genteel836753genteel
gentes75324163gentes
gentian8310103gentian
gentil74115123gentil
gentle74014513gentle
gently103710913gently
gentoo7311313gentoo
gentry103410443gentry
gents65729613gen_ts
genu55929073gen__u
genus65319833gen_us
gerbera1034773gerbera
gerent73223093gerent
gesneria944053gesneria
geta56627443g__eta
gingiva1253273gingiva
gleba83910243g_leba
gone55639043gone__
gonef95221293gone_f
gonefs10439873gonefs
goner66025153gone_r
goners74420163goners
gonia64117533gon_ia
grieve1047243grieve
guava938583g_uava
guinea737613guine_a
gynecia1384233gynecia
henna84414043hen_na
keeve124512123ke_eve
kinema1236013kinema
lenes54738523lene_s
leva77020713__leva
medevac1553523medevac
melena81110473melena
mensa75318663men_sa
menta74424423men_ta
metepa1066013metepa
nema65522523__nema
nene45932063nene__
nenes55329673nene_s
nepeta837893nepeta
neve76224833__neve
nevi75116423__nevi
nova76518953__nova
oedema936573oedema
peeve104915253pe_eve
penes75839223pene_s
penna74520203pen_na
pennia84412973pennia
perea75026443pere_a
pereia85217983pereia
peseta8310573peseta
pesewa1135543pesewa
pineta85815563pineta
reeve84121323re_eve
releve95116403releve
renege72713763renege
renest64529713renest
renew83917513rene_w
renewal1038703renewal
renews93811753renews
reseda739703reseda
selva83014273se_lva
sene46848053sene__
senecas939013senecas
senegas837253senegas
senna54617983sen_na
senora63216153senora
sensa54117473sen_sa
telega736773telega
tenet55542213tene_t
tenets65518953tenets
tenia55324483ten_ia
tinea54923153tine_a
usnea539393usne_a
veena81912323ve_ena
vena76126293ven__a
veneer94511693veneer
venene92912523venene
venery123710663venery
xenia124814773xen_ia
yenta83917043yen_ta
zenana15297983zenana

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 Filter1786911127160.1561145455.1
2DLD Change Limit1127161717.28315476.6
3Display Results1711710.0463717.4
 (SQL Overall)1786911717.48523873.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.