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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
introspectional1972631introspectional_
introspection1764623introspection___
introspections1864063introspection__s
intersectional16146254inters_ectional_
introspecting18123574introspecti_n__g
introspectively2572214introspecti_vely
interjectional23195605int_erjectional_
introjection2156205intro_jection___
introjections2255785intro_jection__s
introspective2073575introspecti___ve
retrospection1784315retrospection___
retrospections1894175retrospection__s
inflectional1754386in___flectional_
insertional1147466in___s_ertional_
inspection1446666in___spection___
inspections1546426in___spection__s
instructional1555096instr___uctional_
insurrectional1662606in_surrectional_
intentional11128846int____entional_
interactional1557006int__eractional_
intersection14610186inters_ection___
intersections1598966inters_ection__s
intonational1256006int_o__national_
intraperitoneal1791196intr_aperitoneal_
intrapersonal1572886intr_ape_rsonal_
introduction1555786intro_duction___
introductions1655136intro_duction__s
introjecting2254256intro_jecti_n__g
introspect1474386introspect______
introspected1752846introspect____ed
introspects15103036introspect_____s
projectional2355426__pro_jectional_
retrospecting1863456retrospecti_n__g
retrospectively2572176retrospecti_vely
bidirectional18152497bidir___ectional_
bisectional1554647___bis_ectional_
connectional1646727___connectional_
contractional1756067contr___actional_
convectional1947047___convectional_
correctional1675327___correctional_
directional1445447_dir___ectional_
disproportional2071927dispro_portional_
improvisational2261657improvisational_
inflectionally2262957in___flectionally
informational1854347in_fo_rmational_
innovational1553837in_no__vational_
inquisitional2272837inquis__itional_
inscriptional17173517inscrip__tional_
inspecting1546227in___specti_n__g
inspectorate1661897in___spect_orate
inspirational1554417in___spirational_
insurrectionary2071347in_surrectionary
intellection1466167int_ellection___
intellections1565397int_ellection__s
intensional11146567int____ensional_
intentionally1655987int____entionally
intercessional1663647int_ercessional_
interconnection1963127interconnection___
interjection2198927int_erjection___
interjections2277997int_erjection__s
international1357677int__ernational_
internationals1454247int__ernationals
interpersonal1564027int_erpe_rsonal_
interregional1453767int_erre_gional_
interrogational1693907interrogational_
intersecting1549717inters_ecti_n__g
interspersion1564397interspersion___
interspersions1663877interspersion__s
intestinal1047517int____esti_nal_
intraspecies1662807intraspec_i___es
intraspecific22171527intraspec_i__fic
introductorily2071477intro_duct_orily
introgression1463057introgression___
introgressions1572857introgression__s
introversion1554087intro_version___
introversions1663697intro_version__s
introverting1654277intro_verti_n__g
intuitional1155297int____uitional_
invocational1754417in_vo__cational_
involutional1553577in_vo__lutional_
irrotational1254027i_rro__tational_
jurisdictional2471197_jurisdictional_
nondirectional1763087_nondirectional_
nonfictional1754857_n__onfictional_
nonoperational1663777_nono_perational_
perspectival2162137_per_specti_val_
productional1794717__pro_ductional_
proportional1655817__pro_portional_
proportionals1764027__pro_portionals
prospecting1845857__prospecti_n__g
prospectively2553157__prospecti_vely
reflectional1753997___reflectional_
retroflection1854047retroflection___
retroflections1953877retroflection__s
retroperitoneal1715927retro_peritoneal_
retrospective2083517retrospecti___ve
retrospectives2192787retrospecti__ves
sectional1149427_____s_ectional_
sectionals1247277_____s_ectionals
tractional1248057__tr___actional_
transactional1553427__transactional_
transductional1782517__transductional_
trisection1245987__tris_ection___
trisections1345647__tris_ection__s
unconventional1963127un_conventional_
unidirectional1762127un_idirectional_
unobjectionable2871737un__objectionable
unprofessional1962597unpro_fessional_
unprofessionals2072017unpro_fessionals
untraditional1463877untr__aditional_
vivisectional2162107_vivis_ectional_

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.373479064.3
2DLD Change Limit950241119.45610049.1
3Display Results1111110.0761460.5
 (SQL Overall)1786911119.90518040.5
 
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.