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

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

70 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
intersubjective29151241intersubjective_
nonsubjective2792515_n_onsubjective_
intellective1754656inte___llective_
interactive1659636inter____active_
interdictive1855316inter___dictive_
interjected2146846inter___ject__ed
interjecting2248396inter___jecti_ng
interjection2198926inter___jecti_on
interjectional23195606inter___jectional
interjections2277996inter___jections
internucleotide18121936internucleotide_
interoceptive2074456inter__oceptive_
interpretive1775846inter__pre_tive_
interruptive1754326interru___ptive_
intersected1448286inters___ect__ed
intersecting1549716inters___ecti_ng
intersection14610186inters___ecti_on
intersectional16146256inters___ectional
intersections1598966inters___ections
interspecies1655096inters__pec_i_es
introspective2073576int_r_ospective_
intussusceptive2281326intussusceptive_
subjective2444966_____subjective_
subjectives2554766_____subjectives
antireflective2271987antir_eflective_
antisubversive2271407ant_isubversive_
imperfective2452757imper___fective_
imperfectives2562047imper___fectives
ineffective2273947in_e___ffective_
injective2178027in______jective_
inspective1746407in___s__pective_
instructive1656487instr_u___ctive_
intellectively2262617inte___llectively
interactively2155177inter____actively
interconnected1962277interconnect__ed
interconnecting2062347interconnecti_ng
interconnection1963127interconnecti_on
interfertile1556427inter___fertile_
interject1849607inter___ject____
interjector2055437inter___ject__or
interjectors2155047inter___ject_ors
interjectory2454517inter___ject_ory
interjects1947537inter___ject___s
internecine1367877inter___nec_ine_
interobserver1861167inter_obse__rver
interoperative1974367inter_operative_
interpolative1865667inter__polative_
interpretative1993807inter_pretative_
interpretively2262937inter__pre_tively
interrogative17104987inter__rogative_
interrogatives18133477inter__rogatives
intersect11412117inters___ect____
intersects1249157inters___ect___s
interservice1754067inters___ervice_
interspecific2261947inters__pec_ific
intersterile1254287inters__te_rile_
interstice1249597inters_____tice_
interstices1348527inters_____tices
introjected2153197int_r__oject__ed
introjecting2254257int_r__ojecti_ng
introjection2156207int_r__ojecti_on
introjections2255787int_r__ojections
introspectively2572217int_r_ospectively
nonobjective2663547_n__onobjective_
perspective2054867__pers__pective_
perspectives2153517__pers__pectives
resubjected2351497__re_subject__ed
resubjecting2451997__re_subjecti_ng
subjectively2953567_____subjectively
surjective2244167_____surjective_

Search took 9 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.356501941.0
2DLD Change Limit95024708.40611304.3
3Display Results70700.0631111.1
 (SQL Overall)178691708.82520248.3
 
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.