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

100 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
introspectional197263(None) 
introspection1764622introspection__
introspections1864062introspection_s
intersectional16146253inters_ectional
introspecting18123573introspecti_n_g
interjectional23195604int_erjectional
introjection2156204intro_jection__
introjections2255784intro_jection_s
introspective2073574introspecti__ve
introspectively2572214introspectively
retrospection1784314retrospection__
retrospections1894174retrospection_s
inflectional1754385in___flectional
insertional1147465in___s_ertional
inspection1446665in___spection__
inspections1546425in___spection_s
instructional1555095instr___uctional
insurrectional1662605in_surrectional
intentional11128845int____entional
interactional1557005int__eractional
intersection14610185inters_ection__
intersections1598965inters_ection_s
intonational1256005int_o__national
intraperitoneal1791195intr_aperitoneal
intrapersonal1572885intr_ape_rsonal
introduction1555785intro_duction__
introductions1655135intro_duction_s
introjecting2254255intro_jecti_n_g
introspect1474385introspect_____
introspected1752845introspect___ed
introspects15103035introspect____s
projectional2355425__pro_jectional
retrospecting1863455retrospecti_n_g
bidirectional18152496bidir___ectional
bisectional1554646___bis_ectional
connectional1646726___connectional
contractional1756066contr___actional
convectional1947046___convectional
correctional1675326___correctional
directional1445446_dir___ectional
disproportional2071926dispro_portional
improvisational2261656improvisational
informational1854346in_fo_rmational
innovational1553836in_no__vational
inquisitional2272836inquis__itional
inscriptional17173516inscrip__tional
inspecting1546226in___specti_n_g
inspirational1554416in___spirational
intellection1466166int_ellection__
intellections1565396int_ellection_s
intensional11146566int____ensional
intercessional1663646int_ercessional
interconnection1963126interconnection__
interjection2198926int_erjection__
interjections2277996int_erjection_s
international1357676int__ernational
interpersonal1564026int_erpe_rsonal
interregional1453766int_erre_gional
interrogational1693906interrogational
intersecting1549716inters_ecti_n_g
interspersion1564396interspersion__
interspersions1663876interspersion_s
intestinal1047516int____esti_nal
intraspecies1662806intraspec_i__es
intraspecific22171526intraspec_i_fic
introgression1463056introgression__
introgressions1572856introgression_s
introversion1554086intro_version__
introversions1663696intro_version_s
introverting1654276intro_verti_n_g
intuitional1155296int____uitional
invocational1754416in_vo__cational
involutional1553576in_vo__lutional
irrotational1254026i_rro__tational
jurisdictional2471196_jurisdictional
nondirectional1763086_nondirectional
nonfictional1754856_n__onfictional
nonoperational1663776_nono_perational
perspectival2162136_per_specti_val
productional1794716__pro_ductional
proportional1655816__pro_portional
prospecting1845856__prospecti_n_g
reflectional1753996___reflectional
retroflection1854046retroflection__
retroflections1953876retroflection_s
retroperitoneal1715926retro_peritoneal
retrospective2083516retrospecti__ve
retrospectively2572176retrospectively
retrospectives2192786retrospecti_ves
sectional1149426_____s_ectional
tractional1248056__tr___actional
transactional1553426__transactional
transductional1782516__transductional
trisection1245986__tris_ection__
trisections1345646__tris_ection_s
unconventional1963126un_conventional
unidirectional1762126un_idirectional
unprofessional1962596unpro_fessional
untraditional1463876untr__aditional
vivisectional2162106_vivis_ectional

Search took 8 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.406440125.6
2DLD Change Limit950241007.12613334.8
3Display Results1001000.0761315.8
 (SQL Overall)1786911007.60823487.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.