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

134 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
genevas118525(None) 
geneva1085851geneva_
enemas8812002_enemas
ganevs10456912ganev_s
genera71211712genera_
general81010932general
generals9109332generals
genes65133092gene__s
geneses82613522geneses
genesis82510822genesis
genets75716662gene_ts
genoas74013622gen_oas
senecas939012senecas
senegas837252senegas
aeneous739893aeneous
aeneus61111143aene_us
agendas936933agen_das
agenes74720253agene__s
ageneses939303ageneses
agenesias1045363agenesias
agenesis938043agenesis
apneas83211383apne_as
beeves114615043be_eves
benes75536233bene__s
canvas113813333can_vas
centas85020703cen_tas
cinemas1138023cinemas
denes65639723dene__s
devas96218883__devas
edemas9310503_edemas
enema7612743_enema_
fanegas1145713fanegas
galeas74618503gale_as
galenas83310333galenas
ganefs10489203gane_fs
ganev95513863ganev__
ganjas14149113gan_jas
geegaw1142853ge_egaw
geegaws1242343ge_egaws
geeks104915843ge_e_ks
gees55647883ge_e__s
geests75912163ge_ests
geishas1135063geishas
geladas936313geladas
gelees74116263gele_es
genders93616783genders
gene56237223gene___
generate9312893generate
generates10312703generates
generic101310753generic
generics11118793generics
generous939763generous
genet66038683gene__t
genetic101211783genetic
genetics11128613genetics
genette838863genette
genettes938303genettes
genial74917613gen_ial
genies75324943gen_ies
genipap1243123genipap
genipaps1342163genipaps
genips9469943gen_ips
genital849793genital
genitals937243genitals
genius74512923gen_ius
genoa64315823gen_oa_
genomes103611703genomes
genoms94412483gen_oms
genres75515623gen_res
genros74211333gen_ros
gens55740073gen___s
gensengs1043093gensengs
gentes75324163gen_tes
gentian8310103gentian
gentians937563gentians
gentles83714343gentles
gentoos838633gentoos
gents65729613gen__ts
genua64614153gen_ua_
genus65319833gen__us
genuses83510883genuses
gerberas1144943gerberas
gerents82612923gerents
getas65421483g__etas
gneiss765953g_neiss
gonefs10439873gone_fs
goners74420163gone_rs
grieves1137323grieves
guavas1037153g_uavas
guineas836743guine_as
hennas94211803hen_nas
keeves133711983ke_eves
kinemas1336883kinemas
lenes54738523lene__s
medevac1553523medevac
medevacs1643373medevacs
melenas999203melenas
mensas85115853men_sas
metepas1136303metepas
nemas75321573__nemas
nenes55329673nene__s
nepetas935943nepetas
neves87021873__neves
nevus84611393__nevus
novas85215363__novas
oedemas1056693oedemas
peeves113814873pe_eves
penes75839223pene__s
pesetas938753pesetas
pesewas1236223pesewas
reeves94721493re_eves
releves103914973releves
reneges82513593reneges
renests74014213renests
renewal1038703renewal
renewals1137273renewals
renews93811753rene_ws
resedas839123resedas
selvas93812913se_lvas
seneca839793seneca_
senega738173senega_
sennas64214233sen_nas
senoras72714953senoras
telegas837443telegas
tenets65518953tene_ts
tenias64720073ten_ias
tineas64616473tine_as
usneas638333usne_as
veenas91410413ve_enas
veneers103710293veneers
venenes102712133venenes
xenias133712973xen_ias
yentas94614213yen_tas
zenanas16286233zenanas

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.203880251.2
2DLD Change Limit1340271347.40318104.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.65223352.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.