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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
superagencies185474(None) 
subagencies1653483su__bagencies
superagency1954103superagenc__y
superagents14117513superagen__ts
supergenes13610933super_gen__es
detergencies1654354deter_gencies
divergencies1963574diver_gencies
emergencies16124514_emer_gencies
impermanencies2261574impermanencies
permanencies1853564__permanencies
sergeancies1444394s__er_geancies
subjacencies2552274su_bjacencies
submergences1952994submer_genc_es
subserviencies2161214subserviencies
superagent131110414superagen___t
superficies1846754super__ficies
supergene12510234super_gen__e_
superheavies2054604super_heavies
superhelices1954314super_helices
supervenes15610074super_ven__es
suzerainties2152664suzera_inties
turgencies1345514tu__r_gencies
urgencies1256644_u__r_gencies
advertencies1853025adver_tencies
agencies1138745_____agencies
appetencies1753735appe__tencies
coagencies1545625___coagencies
coherencies1884775coher__encies
convergencies21143905conver_gencies
currencies1445665cu__r_rencies
decadencies1753875__decadencies
dependencies1854085depe_ndencies
divergences1874495diver_genc_es
emergences15105955_emer_genc_es
epeirogenies1552465_epeirogen_ies
epirogenies1464375_epirogen_ies
esperances1446255espera__nc_es
esuriencies1353825esu__r_iencies
exigencies2045265___exigencies
expediencies2452925expe_diencies
experiences22106055exper_ienc_es
fervencies1845185__fer_vencies
heterogenies1695565heterogen_ies
impermanences2162475impermanenc_es
impertinencies2062145impertinencies
inherencies1656475inher__encies
insurgencies1553585insur_gencies
mergences14137555__mer_genc_es
numeracies1444905numera___cies
parageneses1446205__parageneses
patencies1349175__p__atencies
pendencies1547025__pe_ndencies
perigynies1643965__perigyn_ies
permanences1754495__permanenc_es
pertinencies1654575__pertinencies
petrogenies1466665__petrogen_ies
plangencies1653795__plangencies
progenies12314125__p_rogen_ies
pungencies1544725__p_ungencies
purulencies1553575__purulencies
regencies1249285____regencies
repellencies1663075repe_llencies
sapiencies1445115sap___iencies
sentiencies1346325s__entiencies
sequencies2155995s__e_quencies
sergeanties1253745s__er_geanties
severances1546785severa__nc_es
speakeasies1751325s_pe_akeasies
sporogeneses1554855s_porogeneses
sporogonies1453525s_porogon_ies
stridencies1454035s__tridencies
stringencies1553525s_tringencies
subbranches2052805subbra__nches
submergence1853405submer_genc_e_
subpotencies1852585su_bpotencies
subserviences2061995subservienc_es
subtenancies1653015subtena__ncies
sufferances1953375suffera__nc_es
sufficiencies2361695sufficiencies
suffragettes19131015suffrage_ttes
superableness17127525superablen_ess
superablenesses1964905superablenesses
superannuates1564125superannuates
superathletes1863445superathletes
superbitches2152635super_bitches
superbnesses1695565superbne_sses
supercalender18122875supercalen_der
supercalenders19122385supercalenders
supercedes1578455super_ce__des
supercenter1547115super_cen_ter
supercenters1655755super_centers
superchurches2562085superchurches
supercities15411565super__cities
superelevates1872915superelevates
supereminences2062625supereminenc_es
superettes1249745super__e_ttes
superfamilies2073465superfamilies
superfluities1854145superfluities
superglues1346465super_g__lues
superhelixes2453625super_helixes
superheroes1646535super_he_roes
superheroines1853685super_heroines
superinduces1753905superinduc_es
superiorities1556325superiorities
superlies11314555super____lies
superminis1448555super_min_i_s
supernates12413265super___nates
superplanes1547435superplan__es
superraces1449865super__rac_es
supersecrecies2062305supersecrecies
supersecret1557215super_se_cret
supersedes1379425super_se__des
supersedures1564495super_sedures
supersexes1978045super_se__xes
supersonics1556135super_son_ics
superspecial1853355superspe_cial
superspecials1962725superspe_cials
superspies1449295super___spies
supertonics1555635super_ton_ics
supervene1469445super_ven__e_
supervened1676875super_ven__ed
supervenient1756275super_ven_ient
supervening1755785super_ven_ing
supervention17105995super_vention
superventions18125785super_ventions
suprarenals1352655sup_raren_als
supremacies1773995sup_r_emacies
surgeries10311365su__r_ge_ries
surrogacies1452365su_rrog_acies
vergences15128065__ver_genc_es

Search took 10 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 Filter1786911247900.420425454.8
2DLD Change Limit1247901309.34613352.2
3Display Results1301300.0761710.5
 (SQL Overall)1786911309.84218156.0
 
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.