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

55 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
disaffiliation216333(None) 
disaffiliations2263001disaffiliations
disaffiliating2262272disaffiliating
affiliation1744853___affiliation
disaffiliate1962633disaffiliat__e
disaffiliated2172433disaffiliat_ed
disaffiliates2062523disaffiliat_es
affiliations1844184___affiliations
disaffection2153194disaff__ection
disambiguation2062224disambiguation
disassociation1763284disassociation
disinflation1656574disinf_l_ation
dissimilation1656514dissimil_ation
distillation1347724dis__tillation
affiliating1844165___affiliating
affirmation1953685___affirmation
affixation2344395___affi_xation
affliction1843545___aff_liction
defoliation1548315d___efoliation
desacralization2754165desacralization
desalination13411125desa_li_nation
desalinization2455615desa_linization
despoliation1546705des__poliation
destabilization2763325destabilization
dilapidation1653365dila_pi_dation
disabilities15411105disa_bili_ties
disaffections2253035disaff__ections
disaggregation1862695disaggregation
disambiguations2162145disambiguations
disapprobation2162665disapprobation
disarticulation1863565disarticulation
disassociations1863155disassociations
discrimination1955345dis_crimination
disinclination1763965disinclination
disinfestation18113605disinfestation
disinflations1756275disinf_l_ations
disinformation2063335disinformation
disinhibition1962615disinhibi_tion
disquisition2253325dis_quisi_tion
disrelation1248805dis__rel_ation
dissemination1655775dissemi_nation
dissimilations1755855dissimil_ations
dissimulation1655365dissimul_ation
dissipation1447195dis__si_pation
dissociation1556625dis__sociation
distillations1446935dis__tillations
divarication1855895diva_ri_cation
domiciliation18102505d_omiciliation
filiation121110245_____filiation
insufflation18112875insuff_l_ation
misapplication2263345misapplication
misutilization25155485mis_utilization
officiation1943835___officiation
reaffirmation2152065_reaffirmation
suffixation2452865__suffi_xation

Search took 10 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.266671770.7
2DLD Change Limit95024558.90610669.7
3Display Results55550.0461195.7
 (SQL Overall)178691559.21819385.0
 
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.