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

86 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
intergeneration1673401intergeneration
inteneration1248634int___eneration
intergeneric1563914intergener__i_c
interlineation1455404interline_ation
degeneration1447285__de_generation
integration121310495inte_g___ration
intenerating1346735int___enerating
intenerations1347465int___enerations
interanimation16136015inter_animation
intergradation16114095interg_radation
interlineations1554545interline_ations
intermediation17105215interme_diation
interoperative1974365inter_operative
interpellation1665615interpe_llation
interpenetrate16112995interpenetrat__e
interpenetrated18122075interpenetrat_ed
interpenetrates17112395interpenetrat_es
interpretation16115865inter_pretation
interrelation1358735inter__relation
intervention1568385interven___tion
regeneration1348195__re_generation
cogeneration1546446___cogeneration
degenerating1545666__de_generating
degenerations1546356__de_generations
degenerative1754966__de_generative
generation11312436_____generation
incarceration1753566incar__ceration
incineration1446296in___cineration
indigenization2562626in_digenization
integrating1349496inte_g___rating
integrations13129476inte_g___rations
integrative1547126inte_g___rative
integrator1157126inte_g___rat_or
intenerate1048756int___enerat__e
intenerated1247016int___enerat_ed
intenerates1148096int___enerat_es
interanimations17115196inter_animations
interbehavior2161826inter__behavior
intercalation1557086inter__calation
interception1649406inter__ce_ption
interconnection1963126interconnection
interconversion2072486interconver_sion
interconverting21132596interconver_ting
interdigitation1763146interdigitation
interelectron1564136inter_ele_ctron
interferential1763976interfere_ntial
interfertile1556426inter__fer_tile
intergradations17123456interg_radations
intergrading1545986interg___rading
intergrafting1854146interg___rafting
interiorization2464786interiorization
interjection2198926inter__je_ction
intermediating1853986interme_diating
intermediations1894426interme_diations
intermodulation1893066intermodulation
internalization2455766internalization
interpellating1754536interpe_llating
interpellations1774706interpe_llations
interpellator1563646interpe_llat_or
interpermeating2063076interpermeating
interpolation1558556inter__polation
interpopulation1963596interpopulation
interpretations17134806inter_pretations
interpretative1993806inter_pretative
interrelating1457296inter__relating
interrelations1457616inter__relations
interrogation1457866inter__rogation
intersection14610186inter__se_ction
interspersion1564396inter_sper_sion
interstation12410416inter___station
interstratify1963076inter__stratify
intervener13109026intervener_____
interveners14107306intervener____s
interventions1657516interven___tions
intervisitation1862856intervisitation
itineration1156326i_t___ineration
overgeneralize27193446_overgeneralize
perseveration1853806__perseveration
regenerating1446336__re_generating
regenerations1447146__re_generations
regenerative1655306__re_generative
regenerator1254566__re_generat_or
subgeneration1652616__subgeneration
tergiversation1891446__tergiversation
unregenerate1362176unre_generat__e
unregenerately1871306unre_generately

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.906197230.7
2DLD Change Limit95024868.80010798.2
3Display Results86860.0601433.3
 (SQL Overall)178691869.76618297.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.