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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
genets7571666(None) 
genes65133091gene_s
genet66038681genet_
gentes75324161gentes
gents65729611gen_ts
tenets65518951tenets
aeneus61111142aeneus
agenes74720252agene_s
agents74816292agen_ts
beets76131442be_ets
begets96215522begets
benes75536232bene_s
bennets94712162bennets
bents76033692ben_ts
berets85822522berets
besets85718802besets
cents74730332cen_ts
deets65330242de_ets
denes65639722dene_s
dents65031802den_ts
egrets72712242egrets
ganefs10489202ganefs
ganevs10456912ganevs
gannets83811442gannets
garnets84115402garnets
geeks104915842ge_eks
gees55647882ge_e_s
geest64829622ge_est
geests75912162geests
gelees74116262gelees
gelts65924612ge_lts
gemots93712152gemots
genders93616782genders
gene56237222gene__
genera71211712genera
geneses82613522geneses
genesis82510822genesis
genetic101211782genetic
genetics11128612genetics
genette838862genette
genettes938302genettes
geneva1085852geneva
genevas1185252genevas
genies75324942genies
genips9469942genips
genius74512922genius
genoas74013622genoas
genoms94412482genoms
genres75515622genres
genros74211332genros
gens55740072gen__s
gent56954392gen_t_
genus65319832gen_us
gerents82612922gerents
gestes75721392gestes
gests66028812ge_sts
gets55442482g__ets
gleets75315052gleets
gnats65217712g_nats
godets8410932godets
gonefs10439872gonefs
goners74420172goners
greets75117422greets
gurnets84010792gurnets
hents87330742hen_ts
jennets14517632jennets
keets95123482ke_ets
kentes105118652kentes
leets54927122le_ets
lenes54738522lene_s
lunets66914762lunets
meets74224612me_ets
nenes55329672nene_s
nets45941532__nets
nonets64118702nonets
penes75839222pene_s
relets64025672relets
renest64529712renest
renests74014212renests
renews93811752renews
rennets75212632rennets
rentes65431192rentes
rents55935182ren_ts
resets65427612resets
revets94022172revets
rewets94617212rewets
sennets73712582sennets
telnets738372telnets
tenet55542212tenet_
tents56434212ten_ts
vents86125932ven_ts
weets85427722we_ets
yentes95517602yentes

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 Filter178691825510.343520965.0
2DLD Change Limit82551932.39034540.2
3Display Results93930.0332818.2
 (SQL Overall)178691932.76664602.7
 
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.