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

211 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
pangenes11261282(None) 
pangene102711961pangene_
pangens103112061pangen_s
agenes74720252_a_genes
gangrenes1145062gangrenes
pangen94115912pangen__
pangeneses1346372pangeneses
pangenesis1345812pangenesis
pannes85522852pan__nes
pentenes10315632pentenes
pinenes93416672pin_enes
pongees104212542ponge_es
tangences1246442tangences
tangents938712tangents
achenes12313493_achenes
agene65621583_a_gene_
agents74816293_a_gents
agones75719863_a_gones
akenes104817343_a_kenes
alkenes114212753_alkenes
ancones93116343_ancones
aneles64626293_an_eles
angeled93211513_angeled
angels74416173_ange_ls
angelus8418463_angelus
angered93013473_angered
angers75222543_ange_rs
anginas8310953_anginas
angles74426703_ang_les
annexes1437203_annexes
antigenes10411433_antigenes
apogees1037103apoge_es
arenes64928393_a_renes
argents84014853_argents
augends935883_augends
bangers104020353bange_rs
bangles103617413bang_les
bantengs1134593bantengs
bargees105415873barge_es
benzenes1946853benzenes
bungees104513103bunge_es
cangues10611823cang_ues
canines93724033can_ines
canteens1038573canteens
canzones1939153canzones
cassenes103611293cassenes
congees103517923conge_es
congener112412203congener
congeners122511133congeners
convenes132916913convenes
dangered11248513dangered
dangers94818213dange_rs
dangles93618423dang_les
engines81114463_engines
fanzines2036913fanzines
gangers94418603gange_rs
gangrene1044363gangrene_
gangrened1242733gangrened
gangues9149753gang_ues
gasogenes1145723gasogenes
gazogenes2043693gazogenes
genes65133093___genes
hangers113120813hange_rs
hangings13258583hangings
hangnest12311413hang_nest
haptenes133810823haptenes
indenes82916253_indenes
ingenues947103_ingenues
jangles154015683jang_les
jaygees1854513jayge_es
kanteles1238123kanteles
lagends947273la_gends
lagunes8148523la_gunes
langsynes1342843langsynes
langues81211913lang_ues
largeness1038273largeness
lungees84412143lunge_es
maneges103612143man_eges
manganese1244803manganese
mangels103614493mange_ls
mangers103521263mange_rs
manges94628943mang__es
manginess122010413manginess
mangles104021463mang_les
mangoes104316133mang_oes
mangonel1185763mangonel
mangonels1294373mangonels
margents11410133margents
nankeens1243243nankeens
nenes55329673__n_enes
padrones112711043padrones
pagans95717923pa_gan_s
pageants1136693pa_geants
pagers94423253pa_ge_rs
pages85235073pa_g__es
pagings114411063pa_gings
paleness10312983pa_leness
panaches15310283panaches
pancakes1637073pancakes
pandanus1136433pandanus
pandects1335843pandects
pandered121812573pandered
panderer112210913panderer
panderers12229153panderers
panders103423733pande_rs
pandies104224503pan_dies
pandores11312453pandores
paneled10612573pan_eled
paneless102611763pan_eless
panels84716523pan_e_ls
panes76148693pa___nes
panfries13149203panfries
pangas99921103pang__as
panged104722333pang__ed
pangenetic1554713pangenetic
panging113319113pangin_g
pangrams1337153pangrams
pangs84628663pang___s
panicles121010113panicles
paniers94717333panie_rs
panmixes1934913panmixes
panne76623653pan__ne_
panned94123433pan__ned
panner84224763pan__ner
panners93621273panne_rs
panoches1548123panoches
panpipes1135173panpipes
pansies94521983pan_sies
panties94230933pan_ties
pantiles103617153pantiles
pantries101817393pantries
panzers184012013panze_rs
parcener1238473parcener
parceners1337453parceners
parents93418123pa_rents
pareses94718883pa_reses
parges94529543parg__es
pargeted1238683pargeted
pargets105215193parge_ts
pargings123410163pargings
parietes10714543parietes
parvenues1444643parvenues
parvenus1335653parvenus
patens84820863pa_ten_s
patents94815203pa_tents
pathogenes1645953pathogenes
patiences1367433patiences
patients1088763patients
patines95225763pa_tines
pattened11299393pattened
pattens95414923patten_s
pavanes123612653pa_vanes
pawnees12298173pawne_es
payees114812903pa_ye_es
payments1536943payments
pendents1139413pendents
penes75839223p___enes
pennines103112043pennines
pensees9311203pense_es
pentanes10316083pentanes
pentene9313793pentene_
phosgenes1544763phosgenes
pinbones1238143pinbones
pinene82915643pin_ene_
pingers104020743pinge_rs
pingoes105116523ping_oes
pinkened1535753pinkened
pinkens13419643pinken_s
pinkeyes17335973pinkeyes
pinones94717073pin_ones
planeness1138153plan_eness
plangencies1653793plangencies
plangency1742803plangency
plangent1138803plangen_t
polyenes13510063polyenes
polygenes1557503polygenes
pongee94920193ponge_e_
progenies12314123progenies
propenes122816513propenes
pungencies1544723pungencies
pungency1644093pungency
pungent10311233pungen_t
pungles104013713pung_les
pyrenes123511223p_yrenes
ragees74618663ra_ge_es
raggees93710913ragge_es
ranees64623963ran_e_es
rangers83621043range_rs
ranges73826923rang__es
ranginess101610213ranginess
sageness92111983sa_geness
saneness82313723san_eness
sangers84421943sange_rs
sanguines1047183sanguines
spandexes1943453spandexes
spangles1138893spang_les
tangelos935743tangelos
tangence1146703tangence
tangencies1345753tangencies
tangency1444563tangency
tangent8314993tangen_t
tangerines1147543tangerines
tanginess10239283tanginess
tangles83920043tang_les
transgenes1148403transgenes
venenes102712133ven_enes
wangans1149503wangan_s
wangles113416933wang_les
wanguns1135023wangun_s
whangees15275063whange_es
xanthenes1956353xanthenes

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622117.36019859.0
3Display Results2112110.0802637.5
 (SQL Overall)1786912117.86022734.2
 
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.