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

159 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
potences1271069(None) 
potence11711361potence_
potencies1369301potencies
impotences1645572impotences
patencies1349172patencies
patiences1367432patiences
ponces104720842po__nces
portances1349832portances
potency1457432potenc_y
pounces114113892po_unces
pretences132312612pretences
absences1247673absences
apotheces1644013apotheces
appetences1644593appetences
botanies10312853botanies
bounces113813683bo_unces
butenes9313033buten_es
cadences1338473cadences
coerces11311943co_erces
cogencies1448103cogencies
commences17139583commences
coteries10422703coteries
defences1439633defences
detentes92712873detentes
doyennes1244363doyennes
ententes8312773ententes
essences1047563essences
faiences1337043faiences
fences114617113__fences
florences1446893florences
impotence1545793impotence_
impotencies1754583impotencies
jounces16369853jo_unces
joyances2044413joyances
ketenes114813503keten_es
latencies1147773latencies
licences12129323licences
lozenges1843053lozenges
lucences12137313lucences
neotenies948383neotenies
nonces84418833no__nces
notices9312283not_ices
offences1645023offences
oogenies9311583oogenies
opulences1345093opulences
ounces83617773_o_unces
outfences1456463outfences
patency1466313patenc_y
patens84820863paten__s
patented1188893patented
patentee1099943patentee
patentees1196543patentees
patents94815203paten_ts
patience1247523patience_
patines95225763patin_es
peaces106324083p__eaces
penances12312443penances
pence94924453p__ence_
pencel103812913p__encel
pencels113610053p__encels
penes75839223p__en_es
penitences1447973penitences
pentenes10315633penten_es
pieces104217273p_ie_ces
pierces113411193p_ierces
pinenes93416673pinen_es
pittances1345703pittances
plenches153110623p_lenches
poesies93217403po_esies
poetesses1137233poetesses
poetics11312073poetic_s
poetises10313953poetises
poetizes19310253poetizes
poetries10315583poetries
pointes93216753po_intes
poleaxes1767273poleaxes
polentas1038743polentas
polices113118053po_lices
pollices12410753pollices
polyenes13510063polyen_es
polytenies1547113polytenies
pomaces132712123po_maces
ponce95222513po__nce_
ponced114314813po__nced
pones74547043po__n_es
ponies84833463po__nies
pontes83627853po__ntes
poperies12316793poperies
portance12310123portance_
portended1345643portended
portends11358963porten_ds
portents103512823porten_ts
postfaces1656273postfaces
potables12179703potables
potages102416423pot_ages
potashes1337833potashes
potatoes1039943potatoes
poteen83514263pote__en
poteens92910883pote_ens
potent84223353poten__t
potentates12106333potentates
potently1347403potently
potholes13312933potholes
potiches1539203potiches
potlaches16115263potlaches
potlines10714213potlines
potlucks1643303potlucks
potpies113116173pot_pies
potsies93019483pot_sies
pottages112910453pottages
potteries11313593potteries
potties93723543pot_ties
pottles93816983pot_tles
pounce105214093po_unce_
pounced123510623po_unced
pouncer113511233po_uncer
pouncers12349203po_uncers
poutines102415103poutin_es
prances113618773p_rances
presences132113793presences
pretence122312123pretence_
pretenses112210593pretenses
princes113015143p_rinces
progenies12314123progenies
propenes122816513propen_es
proteases112110833proteases
protects1239743prote_cts
protegees1275393protegees
proteges1149923prote_ges
proteides12238783proteides
protended1336803protended
protends113010353proten_ds
proteomes13248653proteomes
proteoses112211013proteoses
proteuses11238993proteuses
provinces1646853provinces
prudences1446683prudences
pudencies1445783pudencies
pyrenes123511223pyren_es
refences13311843refences
retenes76324623reten_es
romances12310793romances
rotenones956343rotenones
sciences1238773sciences
sentences11610303sentences
silences10310073silences
sonances10310263sonances
spences113413923_spences
stances93715963_stances
stenches132110293_stenches
tenaces92814513__tenaces
tenches123515523__tenches
tenses64722553__tenses
tenues63816443__tenues
terces83921413__terces
twopences1642833twopences
unfences1337933unfences
valences1388513valences
violences1445493violences

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.470380193.6
2DLD Change Limit1461621597.06020702.8
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.59323533.6
 
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.