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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

53 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
miscegenational208110(None) 
miscegenation1863132miscegenation__
miscegenations1963022miscegenation_s
dispensational1762505dispe_nsational
dissertational1562575disse_rtational
inclinational1553925_inc_linational
international1357665_inte_rnational
migrational1444735mi___g_rational
miscreation1547715misc_re_ation__
miscreations1647055misc_re_ation_s
vegetational1653375___vegetational
aggregational1662226aggreg__ational
ascensional1362776_asc__en_sional
binational1246376bi_____national
bisectional1554636bis___e_ctional
cognitional1454266___cog_nitional
declinational1652926_dec_linational
dissemination1655796dissemination__
disseminations1755086dissemination_s
documentational2061966_documentational
generational1354816___generational
ideational1146496_i___de_ational
immigrational1851926_immig_rational
impregnation1754016impreg_nation__
impregnations1853776impreg_nation_s
incantational1553566_inc_antational
intentional11128836_i__nten_tional
internationals1454236_inte_rnationals
intonational1256006_i__ntonational
mediational1445636m___e_diational
miscitation1547776misc__itation__
miscitations1647056misc__itation_s
misconnection1954136misconnection__
misconnections2063816misconnection_s
miscorrelation1873236miscorrelation__
miscorrelations1963006miscorrelation_s
miscreating1648496misc_re_ati_n_g
miseducation1793456mis_education__
miseducations18113296mis_education_s
misorientation1693186misorientation__
misorientations1783056misorientation_s
multinational1553756m__ultinational
negational1147156___neg__ational
observational1853176obs_e_rvational
oscillational1552216_osc_illational
presentational1673216__presentational
recreational1455166_rec_re_ational
sensational1146386__s_e_nsational
speciational1654316__spe_ciational
subnational1354576__s__ubnational
supernational1555616__supernational
supranational1552996__supranational
unsensational1353666uns_e_nsational

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 Filter178691950240.1231452772.4
2DLD Change Limit95024537.43612778.9
3Display Results53530.0501060.0
 (SQL Overall)178691537.60923484.2
 
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.