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

65 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
introgression146305(None) 
introgressions1572851introgressions
introgressive1762792introgressive
retrogression14103422retrogression
ingression1145513in___gression
introgressant14161993introgressant
intromission14143203intro_mission
introversion1554083intro_version
progression1455883__progression
retrogressions15113163retrogressions
antiaggression16101584antiaggression
ingressions1245494in___gressions
intercession14226444int_ercession
intersession12175814int_ersession
introgressants15201394introgressants
introjection2156204intro_jection
intromissions15142794intro_missions
introspection1764624introspection
introversions1663694intro_versions
progressions1555554__progressions
regression1146954___regression
retrocession1494454retro_cession
retrogressing1553164retrogressing
retrogressive1762644retrogressive
unprogressive1962504unprogressive
aggression1253945___aggression
antidepression1771805antidepression
antiprogressive2171485antiprogressive
antirecession1562675antirecession
derepression1593135_derepression
digression1244665___digression
egression1046195____egression
extroversion2282285extro_version
impression1447095i___mpression
indigestion1353755in_dig_estion
ingestion10137485in___g_estion
ingressive1455265in___gressive
integration121310495int_egr_ation
intension948495int____ension
intercessions15225885int_ercessions
interconversion2072485interconversion
interfusion1464985int__erfusion
intermission1464655int_ermission
intersessions13195285int_ersessions
interspersion1564395interspersion
introduction1555785intro_duction
introjections2255785intro_jections
introspections1864065introspections
introversive1863215intro_versive
intrusion946815int___r_usion
nonaggression1561695nonaggression
nonprogressive2072045nonprogressive
procession1448415__pro_cession
profession1546595__pro_fession
progressing1545775__progressing
progressional1663965__progressional
progressive1755185__progressive
regressions1247105___regressions
repression1249045___repression
retrocessions15114355retro_cessions
retrogress1143425retrogress___
retrogressed1452715retrogress_ed
retrogresses1353565retrogress_es
retroversion1573675retro_version
transgression1462695transgression

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 Filter1786911247900.393454684.5
2DLD Change Limit124790659.40613267.1
3Display Results65650.0461413.0
 (SQL Overall)178691659.84518150.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.