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

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

85 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
miscegenations196302(None) 
miscegenation1863131miscegenation_
miscegenational2081102miscegenational
miscreations1647063misc_re_ations
disseminations1755084disseminations
impregnations1853774impreg_nations
miscitations1647054misc__itations
misconnections2063814misconnections
miscorrelations1963004miscorrelations
miscreation1547724misc_re_ation_
miseducations18113294mis_educations
misorientations1783054misorientations
accelerations1754195_accelerations
asseverations1652595_asseverations
assignations1344165_assig_nations
catenations1348365___catenations
cementations1659015___cementations
cognations1339595___cog_nations
concatenations1873725concatenations
crenations12511695___c_renations
decelerations1646425_decelerations
deoxygenations2661745deoxygenations
desegregations1763565des_egregations
designations1456945des_ig_nations
disaggregations1962515disaggregations
disclamations1853725disc_lamations
discolorations17104305discolorations
disconnections1954025disconnections
discretions1447225disc_re__tions
discriminations2074605discriminations
disorientations1683625disorientations
dispensations1655485dispe_nsations
disrelations1348505dis__relations
dissemination1655795dissemination_
dissentions12168045dis__sen_tions
dissertations1465895disse_rtations
distentions12178845dis__ten_tions
eviscerations1882705evisc__erations
fascinations1746375fasc__inations
halogenations1772935_halogenations
hibernations1744055hi_be_rnations
hydrogenations22103245hydrogenations
imaginations1546345_i_maginations
implementations2162885implementations
impregnation1754015impreg_nation_
incarnations1446665_inc_arnations
incinerations1545685_incinerations
inclinations1448755_inc_linations
indignations1446045_indig_nations
inseminations1546245_inseminations
integrations13129475_integ_rations
intenerations1347465_intenerations
invaginations1755085_invaginations
macerations1548475m_ac__erations
machinations19115765m_ac_hinations
marginations1546455m__arginations
mercerizations2756105mercerizations
migrations13168685mi___g_rations
misallocations1853095misallocations
miscalculations2172835miscalculations
miscaptions1744185misc___aptions
miscitation1547775misc__itation_
miscomputations2392265miscomputations
misconceptions2263575misconceptions
misconnection1954135misconnection_
miscorrelation1873235miscorrelation_
miscreating1648495misc_re_ati_ng
misdirections1854235misdire_ctions
miseducation1793455mis_education_
misestimations18144425misestimations
misevaluations19133455misevaluations
misfunctions1953715mis__functions
mislocations16145655mis__locations
misorientation1693185misorientation_
misperceptions2262485misperceptions
misquotations24182725mis_quotations
mitigations1447625mi_tig__ations
oxygenations2352695__oxygenations
resegregations1653695res_egregations
resignations1346885res_ig_nations
revegetations17114715_revegetations
segmentations1655595__s_egmentations
segregations1445805__s_egregations
stagnations1244905__stag_nations
vegetations1547325___vegetations

Search took 7 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.360496363.9
2DLD Change Limit95024856.56314478.7
3Display Results85850.0601416.7
 (SQL Overall)178691856.98325589.4
 
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.