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

73 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
miscalculation208303(None) 
miscalculations2172831miscalculations
miscalculating2161952miscalculating
calculation1548293___calculation
miscalculate1872403miscalculat__e
miscalculated2072173miscalculat_ed
miscalculates19102353miscalculat_es
recalculation17114593_recalculation
calculations1647074___calculations
fasciculation20133564fasc_iculation
maculation14510984m___a_culation
misallocation1753364mis_allocation
miscomputation2292304miscomputation
miscorrelation1873234miscorrelation
misevaluation18153624miseval_u_ation
recalculations18104034_recalculations
sacculation1547844__s_acculation
calcination1548905___calcination
calculating1666795___calculating
calculational1752585___calculational
calculator1485425___calculat_or
cancelation1547775___cancelation
circulation1549395___circulation
disarticulation1863575disarticulation
disclamation1754245disc_l_amation
discoloration16124725discol_oration
disconsolation1763415disconsolation
dissimulation1655375dis_simulation
distillation1347745distil__lation
ejaculation2096135__eja_culation
emasculation1655235__emasculation
encapsulation1752295_encapsulation
escalation1248875_esca___lation
fasciculations21133095fasc_iculations
flocculation1952805floc__culation
gesticulation1694705ges_ticulation
incarceration1753565_incarceration
inculcation1557245_inculc__ation
inoculation1358715_i__noculation
inosculation1445275_i_nosculation
installation1254915instal__lation
machicolation22112275m_achicolation
maculations1569625m___a_culations
matriculation17125385m_atriculation
micropulsation2082515mi_cropulsation
misallocations1853095mis_allocations
misassumption1961505mis_assumption
miscaption1644765misca____ption
miscegenation1863135misc_egenation
miscitation1547775mis___citation
miscomputations2392265miscomputations
misconception2163995misconc_eption
miscorrelations1963005miscorrelations
miscreation1547725mis___creation
miseducation1793455mis__education
misevaluations19133455miseval_u_ations
mislocation15126415mis__l_ocation
mistranslation16123175mistranslation
misvocalization3163055misvocal_ization
musicalization2795455musical_ization
oscillation1345505_oscil__lation
osculation1249675_os___culation
recalculating1853645_recalculating
recirculation1764905_recirculation
sacculations1646665__s_acculations
salutation1048905__s_al_utation
scalation11311075__sca___lation
spallation1247025__spal__lation
speculation1547545__s_peculation
spiculation1547035__s_piculation
uncalculating1851955_uncalculating
vesiculation1746115ves__iculation
visualization2557935visual_ization

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.376475242.0
2DLD Change Limit95024736.23315245.3
3Display Results73730.0461587.0
 (SQL Overall)178691736.65526850.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.