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

196 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
supernational155561(None) 
supernation13411662supernation__
supernations14410872supernation_s
supranational1552992supranational
hyperrational2153933hyperrational
international1357673international
operational1347523_oper_ational
speciational1654313s_peciational
subnational1354573su__bnational
subrational1345493su_br_ational
supernatural1453663supernat_ural
superregional1662363superregional
suprarational1552923suprarational
aberrational1453484_aberrational
aspirational1455004aspir_ational
expectational2452494expectational
generational1354824gener_ational
internationals1454244internationals
multinational1553764multinational
observational1853184observational
perorational1446394__perorational
sensational1146384s__ensational
spermatial1445674s_permati__al
subornation1346494subornation__
subornations1446144subornation_s
summational1553684su__mmational
supernatant1356314supernat_an_t
supernatants1454474supernat_ants
supernaturals1572984supernat_urals
superpersonal1762354superpersonal
superregionals1761304superregionals
superstation14168624superstation__
superstations15208144superstation_s
supination1249884sup_ination__
supinations1348834sup_ination_s
suppositional1763064suppositional
aggregational1662225aggregational
alternation1147625alternation__
alternations1246775alternation_s
annexational1953265anne_xational
antinational1297485_antinational
antirational1278495antir_ational
apparitional1652765appar_itional
attentional1154205atte_n_tional
binational1246375___binational
combinational1984085combinational
compensational2073525compensational
conservational1955345conservational
conversational1954165conversational
correlational15113675correlational
cupellation1544145cupellation__
cupellations1643805cupellation_s
cybernation1843915cybernation__
cybernations1943605cybernation_s
declinational1652925declinational
deformational19122975deformational
derivational1654265__derivational
dispensational1762505dispensational
dissertational1562575dissertational
equational1945605___equational
examinational2252185examinational
explorational2252555explorational
functional15116675fu___nctional
gestational1245115__gestational
gubernatorial1661275gubernatorial
gyrational1444745__gyr_ational
hibernation1644095hibernation__
hibernations1744055hibernation_s
hyperemotional2461815hyperemotional
hyperfunctional2881355hyperfunctional
ideational1146505_ide__ational
inclinational1553935inclinational
informational1854345informational
insertional1147465inser__tional
inspirational1554415inspir_ational
intentional11128845inte_n_tional
interactional1557005interactional
internationally1873715internationally
intonational1256005_intonational
irrational1047215___irrational
junctional19105365ju___nctional
librational1344555_libr_ational
maturational1454185matur_ational
mediational1445645__mediational
migrational1444745_migr_ational
multinationals1662225multinationals
mutational1246515mu___tational
narrational1145445__narrational
national8311535_____national
negational1147155__ne_gational
nonnational11107835__nonnational
nonoperational1663775nonoper_ational
nonrational11109125_nonr_ational
numeration12137965numer_ation__
numerations13127295numer_ation_s
nutational1047045nu___tational
nutritional1154785nu_tr_itional
operation11314005_oper_ation__
operationally1854645_oper_ationally
operations12312955_oper_ation_s
orientational1353805orientational
pentagonal1363565__pe_ntagonal
perceptional1854905__perceptional
permutational1752695__permutational
populational1654415pop_ulational
preoperational1853245preoper_ational
probational1547085__probational
rational8412545____r_ational
recreational1455175_recreational
reformational18113425reformational
relational1047715__re_lational
repetitional1453725repe_titional
reputational1474585rep_utational
salutational1253325s_alutational
salvational1443715s__alvational
scarlatinal13102085s_carlati_nal
sectional1149425s__e__ctional
separation12510435separ_ation__
separations1369275separ_ation_s
septentrional1581285septentrional
seriation9318065s__eriation__
seriations10316685s__eriation_s
serotinal947215s__er_oti_nal
serration9414065s__erration__
serrations10313095s__erration_s
situational1144585s__ituational
speciation1449395s_peciation__
speciations1548485s_peciation_s
spermatia1346745s_permati__a_
spermatogonial19161935s_permatogonial
spermatozoal2561925s_permatozoal
stational948515s____tational
suberization2359245suberization__
suberizations2468775suberization_s
subregional1452365su_br_egional
suctional1147685su____ctional
sulfonation1444265sulfonation__
sulfonations1543925sulfonation_s
superannuation16104225superannuation__
superannuations1763805superannuation_s
superatom1348915super_at_o__m
superatoms1448395super_at_o_ms
supercabinet1855965supercabi_net
supercautious1753925supercautio_us
supercriminal1962365supercriminal
supercritical1973485supercritical
superfetation1855225superfetation__
superfetations1975065superfetation_s
superficial1854405super__ficial
superheating18126515superheati_n_g
superhelical1953115superheli_cal
superlain1148995superla_i_n__
superlative1648255superlati__ve
superlatively2174055superlatively
superlatives1756575superlati_ves
supernal1039875super_____nal
supernate11313275supernat____e
supernates12413265supernat___es
supernaturally1962605supernaturally
supernature1355515supernat__ure
supernatures1455225supernat_ures
supernormal1553715supern__ormal
supernova1444845supern___ova_
supernovae1544635supern___ovae
supernovas1564765supern___ovas
superpatriot1655075superpatrio__t
superpatriotic2081955superpatriotic
superpatriots1753825superpatrio_ts
superstition14166875superstition__
superstitions15176785superstition_s
superstrong14125045super_stron_g
supertonic1446955super__t_onic
supervention17105995supervention__
superventions18125785supervention_s
supervision1655035supervision__
supervisions1755035supervision_s
supinating1357835sup_inati_n_g
suppuration1545895suppuration__
suppurations1645205suppuration_s
supraliminal1661385sup_r_aliminal
suprarenal1253065sup_r_a_renal
supravital1552345sup_r_avi_tal
suspiration1346545suspir_ation__
suspirations1445855suspir_ation_s
susurration1144795susurration__
susurrations1244335susurration_s
terminational1553485terminational
transnational1353915transnational
ultrarational1363515_ultrarational
unemotional1353495_une_motional
unsensational1353665unsensational
variational1444775__variational
vegetational1653375vege_tational
vernation12311085__vernation__
vernations13310335__vernation_s
vibrational1644365_vibr_ational

Search took 12 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.403443402.0
2DLD Change Limit12479019610.54611832.9
3Display Results1961960.1261555.6
 (SQL Overall)17869119611.07516134.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.