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

104 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
suprarational155292(None) 
supranational1552991supranational
subrational1345493su__brational
supernational1555613supernational
ultrarational1363503ultrarational
aberrational1453484aber_rational
apparitional1652764_apparitional
aspirational1454994asp_irational
explorational2252554explorational
gradational1354464__gradational
hyperrational2153934hyperrational
irrational1047204__ir_rational
narrational1145434_nar_rational
operational1347504_op_erational
perorational1446384_perorational
probational1547084__probational
separation12510434sep_aration__
separations1369274sep_aration_s
speciational1654314s_peciational
subnational1354574su__bnational
summational1553684su__mmational
superregional1662364superregional
suppositional1763064suppositional
suppuration1545894suppuration__
suppurations1645204suppuration_s
supraliminal1661384supralimi_nal
suprarenal1253064suprar___enal
aggregational1662225aggregational
antirational1278445_antirational
arbitrational1553175arbitrational
correlational15113665correlational
depravation1785695depravation__
depravations1885375depravation_s
derivational1654265_derivational
dilatational1352775_dilatational
excavational2452765_excavational
expectational2452495expectational
fractional1547125__fra_ctional
generational1354815_generational
gyrational1444745___gyrational
immigrational1851915immigrational
inhalational1553045_inhalational
inspirational1554395inspirational
irrationals1154725__ir_rationals
irrotational1254025_irrotational
librational1344545__librational
maturational1454175_maturational
migrational1444725__migrational
multinational1553755multinational
mutational1246515mu___tational
nonrational11109095__nonrational
nutational1047045nu___tational
nutritional1154775nu__tritional
populational1654415pop_ulational
promotional1555635__promotional
proration11415985__proration__
prorations12314445__proration_s
radiational1245935___radiational
rational8412545_____rational
recreational1455165recr_eational
relational1047715___relational
reparation12612725rep_aration__
reparations13611655rep_aration_s
reputational1474585rep_utational
rotational1048095___rotational
salutational1253325s_alutational
salvational1443715s__alvational
scarlatinal13102085scar_lati_nal
sensational1146385s__ensational
separating1348645sep_arati_n_g
separationist1555275sep_arationist
serration9414055s_er_ration__
serrations10313075s_er_ration_s
situational1144585s__ituational
spartina1037985s_p_ar_ti_na_
spartinas1135795s_p_ar_ti_nas
stational948515s____tational
submarginal1652155submar_gi_nal
subregional1452365su__bregional
subrogation1446005subrogation__
subrogations1545455subrogation_s
suctional1147685su____ctional
supercriminal1962365supercrimi_nal
supercritical1973485supercriti_cal
supernation13411665supernation__
supernations14410875supernation_s
superregionals1761305superregionals
superstation14168625superstation__
superstations15208145superstation_s
supination1249885sup_ination__
supinations1348835sup_ination_s
suppurating1644595suppurati_n_g
supraorbital1661375supraorbi_tal
suprarenals1352655suprar___enals
supravital1552345sup__ravi_tal
suspiration1346545suspiration__
suspirations1445855suspiration_s
susurration1144795susurration__
susurrations1244335susurration_s
tractional1248035__tra_ctional
traditional1255355__traditional
untraditional1463865untraditional
variational1444775_var_iational
vibrational1644355__vibrational

Search took 9 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.1431249587.4
2DLD Change Limit1247901048.51314658.8
3Display Results1041040.0631650.8
 (SQL Overall)1786911048.71920494.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.