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

125 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
polyenes1351006(None) 
polyene1259361polyene_
polygenes1557501polygenes
poleyns1236112poleyn_s
pollees93215332polle_es
pollened1157782pollened
pollens93713302pollen_s
polyenic1547672polyenic
polygene1456692polygene_
polypnea1544252polypnea
polypneas1644002polypneas
polytene1367602polytene_
polytenies1547112polytenies
polythenes1865462polythenes
toluenes836762toluenes
alkenes114212753_alkenes
amylenes13105703amylenes
apolunes1045293apol_unes
boletes9316063bol_etes
colleens1036843colleens
colleges112410523colleges
colognes11310603colognes
colones96124433col_ones
convenes132916913convenes
dolmens10388693dolmen_s
doyennes1244363do_yennes
doyens104810223do_yen_s
goldener1045403goldener
goldenest1147873goldenest
goldeyes1344483goldeyes
lenes54738523__l_enes
oleines7313393_oleines
oyezes1835053_o_yezes
paleness10312983pal_eness
pangenes112612823pangenes
payees114812903p_aye_es
penes75839223p___enes
pentenes10315633pentenes
phosgenes1544763phosgenes
phyleses1645183phyleses
pilsener1044753pilsener
pilseners1144943pilseners
pinenes93416673p_inenes
planes85028083p_l_anes
plebes104313623p_l_ebes
plexes155313543p_l_exes
plyers114912983p_lye_rs
polders103617373polde_rs
poleaxes1767273poleaxes
poleis86018353pol_e_is
poleless1089873pol_eless
polenta9310093pol_enta
polentas1038743pol_entas
polers84225643pol_e_rs
poles75351003pol___es
poleyn1157323poleyn__
polices113118053pol_ices
policies122415663policies
polies84034583pol__ies
polishes13711783polishes
politeness1247983politeness
polities102722343polities
pollee83623273polle_e_
pollen83416453pollen__
pollenates1246743pollenates
pollenoses12144813pollenoses
pollers93420023polle_rs
pollices12410753pollices
pollutes1037613pollutes
polyamines1746583polyamines
polychetes2045103polychetes
polycots1547763polycots
polyester1445353polyester
polyesters1545233polyesters
polygeneses1754583polygeneses
polygenesis1754063polygenesis
polygenic1746493polygenic
polygonies1646803polygonies
polygons1447723polygons
polygynies1944743polygynies
polymer1438063poly_mer
polymers1538333polymers
polynya1544063poly_nya
polynyas1644453polynyas
polynyi1544093poly_nyi
polyols1238493poly_ols
polyomas1546993polyomas
polyped1537173poly_ped
polypeds1645773polypeds
polyphones2046963polyphones
polypides1747073polypides
polypneic1854063polypneic
polypods1647113polypods
polypores1648003polypores
polypous1547983polypous
polyps13479763poly__ps
polypus14346933poly_pus
polypuses1645603polypuses
polys105718763poly___s
polysemies1765053polysemies
polysomes1647373polysomes
polyteny1665193polyten_y
polythene1765043polythene_
polytypes1945173polytypes
pones74547043po___nes
pongees104212543ponge_es
portends11358963portends
portents103512823portents
posteens10309733posteens
poteens92910883poteen_s
potences12710693po_tences
potheens13266483potheens
potlines10714213potlines
potteens10256793potteens
poutines102415103poutines
prolines102619693prol_ines
propenes122816513propenes
propylenes1744373propylenes
pyrenes123511223p_yrenes
soleness8814263sol_eness
solfeges1244083solfeges
solvents1136763solvents
tolanes74216313tol_anes
toluene736463toluene_
xylenes1745093xyl_enes

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.406440125.6
2DLD Change Limit1461621257.48619524.7
3Display Results1251250.0462717.4
 (SQL Overall)1786911257.93822510.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.