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

140 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
genu5592907(None) 
gen45950511gen_
gene56237221gene
gens55740071gens
gent56954391gent
genua64614151genua
genus65319831genus
gnu45522041g_nu
menu65130221menu
agene65621582agene
agent65829642agent
beau66137272beau
bedu75923692bedu
ben56554922ben_
bend76435262bend
bene66439492bene
bens65945702bens
bent67759912bent
cent67451012cent
centu76119412centu
den47554342den_
dene56643412dene
deni56929392deni
dens55945072dens
dent57158412dent
deny86027122deny
eau37450942_eau
ecu56828232_ecu
emu55929982_emu
en28052392_en_
end46834352_end
eng46726782_eng
ens37245922_ens
enuf7323842_enuf
fen66851352fen_
fend84832972fend
fens76139762fens
feu67843662fe_u
gaen57329602gaen_
gan48060122gan_
gane55145292gane
gang66031962gang
gaun56427712gaun
gear55934972gear
geck115721992geck
ged57044532ge_d
geds66730812geds
gee45359202ge_e
geed65435502geed
geek95327022geek
gees55647882gees
geez146424862geez
gel45642432ge_l
geld65828432geld
gels56836102gels
gelt56448012gelt
gem66840222ge_m
gems75329112gems
genes65133092genes
genet66038682genet
genic85119392genic
genie66124922genie
genii64514172genii
genip84415202genip
genius74512922genius
genoa64315822genoa
genom83716842genom
genre66016802genre
genro64914032genro
gents65729612gents
germ75428962germ
gest56149132gest
get47467462ge_t
geta56627442geta
gets55442482gets
getup83410262getup
geum75424552geum
gey75738302ge_y
gien56330022gien_
gin46055752gin_
gink97129522gink
gins55543952gins
glen56027202glen_
glens66519852glens
gnus56518002g_nus
gone55639042gone
gong66827192gong
gun47240802gun_
gunk95423572gunk
guns55533482guns
guru54623912guru
hen67555272hen_
hens75642572hens
hent76656382hent
jehu145614862jehu
jeu105532072je_u
ken76343982ken_
keno87926432keno
kens85435232kens
kent86846962kent
leku86519912leku
lend56233672lend
leno47331392leno
lens46146492lens
lent46360532lent
leu36047402le_u
men59252842men_
mend75334022mend
meno66031352meno
menus75822842menus
meou65325862meou
nene45932062nene
nu26331952__nu
pen56558842pen_
pend75934532pend
pens65649642pens
pent66559072pent
rend56136572rend
rent46661242rent
sen36058522sen_
send55237292send
sene46848052sene
sent46963012sent
ten35856112ten_
tend56433772tend
tendu67216002tendu
tens45647412tens
tent46159862tent
vena76126292vena
vend86626422vend
vent76049052vent
venue84918212venue
venus84918902venus
wen66249602wen_
wend85330452wend
wens76337932wens
went76051872went
yen66847382yen_
yens75832262yens
zebu153414722zebu

Search took 2 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.1401276364.3
2DLD Change Limit298721401.01629401.6
3Display Results1401400.0304666.7
 (SQL Overall)1786911401.186150666.9
 
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.