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

258 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
pangene10271196(None) 
pangen94115911pangen_
pangenes112612821pangenes
pangens103112061pangens
agene65621582_a_gene
gangrene1044362gangrene
panged104722332pange_d
panging113319112panging
panne76623652pan__ne
pentene9313792pentene
pinene82915642pin_ene
plangent1138802plangent
pongee94920192ponge_e
pungent10311232pungent
tangence1146702tangence
tangent8314992tangent
achene11313813_achene
agee56241493_a_ge_e
agenes74720253_a_genes
agent65829643_a_gent
agone65924553_a_gone
akene95818663_a_kene
alkene104114003_alkene
ancone83916953_ancone
anele55628833_an_ele
anent54931843_an_ent
angel65019563_ange_l
angeled93211503_angeled
angels74416173_angels
anger66225873_ange_r
angered93013473_angered
angers75222543_angers
angina7413133_angina
angle64528873_ang_le
anguine839913_anguine
annexe1337813_annexe
antigene9410203_antigene
anyone94612733_anyone
apogee9312553apoge_e
arene55329413_a_rene
argent74023663_argent
augend837633_augend
banged104923723bange_d
banger94423633bange_r
bangers104020353bangers
banging114019863banging
bangle94018953bang_le
banteng1046363banteng
bargee94624443barge_e
benzene1836343benzene
bungee96319773bunge_e
candent10417363candent
cangue91012443cang_ue
canine83826703can_ine
canteen9411083canteen
canzone1858813canzone
cassene93111543cassene
congee96024463conge_e
congener112412203congener
convene123314323convene
danged94819483dange_d
danger83722823dange_r
dangered11248513dangered
dangers94818213dangers
danging103716093danging
dangle84119303dang_le
engine71114863_engine
epigene1037893epigene
fanged114318223fange_d
fanzine1937123fanzine
ganged94619193gange_d
ganger83721463gange_r
gangers94418603gangers
ganging103216193ganging
gangrened1242733gangrened
gangrenes1145063gangrenes
gangue81310573gang_ue
gasogene1045303gasogene
gazogene1943553gazogene
gene56237223___gene
hanged114222393hange_d
hanger104023253hange_r
hangers113120813hangers
hanging123518703hanging
hangmen1337383hangmen_
haptene123810933haptene
indene73215373_indene
ingenue847133_ingenue
jangle144416293jang_le
jaygee1759463jayge_e
kantele1138253kantele
lagend838743la_gend
lagune7158633la_gune
langsyne1242823langsyne
langue71012173lang_ue
lungee75119813lunge_e
manege94113203man_ege
mange84930193mang__e
mangel94017533mange_l
mangels103614493mangels
manger94325003mange_r
mangers103521263mangers
manges94628943mange_s
mangey123614523mange_y
mangle93921323mang_le
mangonel1185763mangonel
margent10316693margent
nankeen1135043nankeen
nene45932063__n_ene
neogene847553neogene
padrone102512073padrone
pagan86121163pa_gan_
pagans95717923pa_gans
page76036103pa_g__e
pageant10312783pa_geant
paged95926783pa_ge_d
pager84728203pa_ge_r
pagers94423253pa_gers
pages85235073pa_ge_s
paging104020403pa_ging
paleae84820293pa_leae
paleogene1245233paleogene
panache1458423panache
pancake1536673pancake
pandani1039903pandani
pandect12310953pandect
pander93725523pande_r
pandered121812573pandered
panderer112210913panderer
panders103423733panders
pandore10411853pandore
pane64950293pa___ne
paned85437183pan_e_d
panel76023623pan_e_l
paneled10612573pan_eled
panels84716523pan_els
panes76148693pan_e_s
pang75336293pang___
panga85323533pang__a
pangas99921103pang_as
pangeneses1346373pangeneses
pangenesis1345813pangenesis
pangenetic1554713pangenetic
pangram1239023pangram
pangs84628663pang__s
panicle11129983panicle
panier84425503panie_r
paniers94717333paniers
panini8314273pan_ini
panino8315683pan_ino
panned94123433panne_d
panner84224763panne_r
panners93621273panners
pannes85522853panne_s
panning104019393panning
panoche1456383panoche
panpipe1034833panpipe
panted95024823pante_d
pantie84326473pan_tie
pantile93918483pantile
panting104025423panting
panzer174213233panze_r
panzers184012013panzers
parcener1238473parcener
pardee93922023parde_e
pardine103616723pardine
parent83230423pa_rent
pareve114613013pa_reve
parge85831853parg__e
parged104922043parge_d
parges94529543parge_s
parget94529393parge_t
pargeted1238673pargeted
pargets105215193pargets
parging113318603parging
parvenu1247023parvenu
parvenue1344923parvenue
passee84522023passe_e
paten74827343pa_ten_
patens84820863pa_tens
patent84524923pa_tent
pathogene1545193pathogene
patience1247523patience
patient9617073patient
patine85328123pa_tine
pattee84323383patte_e
patten84418193patten_
pattened11299393pattened
pattens95414923pattens
pavane114113443pa_vane
pawnee113115403pawne_e
payee105524723pa_ye_e
payment14310703payment
pendent10314723pendent
penmen10311493penmen_
penne75423853pen__ne
pennine93712953pennine
pensee8417313pense_e
pentane9415743pentane
pentenes10315633pentenes
phosgene1444103phosgene
pinbone1138183pinbone
pinenes93416673pin_enes
pinged104321383pinge_d
pinger94324093pinge_r
pingers104020743pingers
pinging113419553pinging
pinken124513283pinken_
pinkened1535753pinkened
pinkens13419643pinkens
pinkeye16326493pinkeye
plangency1742803plangency
polyene1259363polyene
polygene1456693polygene
ponent82821593pon_ent
ponged105619353ponge_d
pongees104212543pongees
ponging113416153ponging
pontine92419053pontine
pranged114512553prange_d
pranging123012723pranging
progeny1389463progeny
propene112716043propene
pungency1644093pungency
pungle94413573pung_le
pyrene113210733p_yrene
ragee65432663ra_ge_e
raggee84217603ragge_e
ranee55438103ran_e_e
range64728413rang__e
ranged84824313range_d
ranger73925523range_r
rangers83621043rangers
ranges73826923range_s
ranging94120263ranging
ringent8315153ringent
sanger74524563sange_r
sangers84421943sangers
sanguine947633sanguine
spangle1038403spang_le
tanged84622493tange_d
tangelo837033tangelo
tangences1246443tangences
tangency1444563tangency
tangents938713tangents
tangerine1048403tangerine
tanging93419523tanging
tangle74019953tang_le
transgene1047953transgene
vanmen1138403vanmen_
venene92912523ven_ene
wangan10311223wangan_
wangans1149503wangans
wangle103817503wang_le
wangun1037103wangun_
wanguns1135023wanguns
whangee14268613whange_e
xanthene1855553xanthene

Search took 7 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.1531167915.0
2DLD Change Limit1340272585.95622502.9
3Display Results2582580.0932774.2
 (SQL Overall)1786912586.20228811.8
 
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.