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

87 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
introspections186406(None) 
introspection1764621introspection_
introjections2255782intro_jections
introspecting18123572introspecti_ng
introspectional1972622introspectional
retrospections1894172retrospections
inspections1546423in___spections
intersections1598963inters_ections
introductions1655133intro_ductions
introjection2156203intro_jection_
introspective2073573introspecti_ve
introspects15103033introspect___s
retrospection1784313retrospection_
inspection1446664in___spection_
intellections1565384int_ellections
interjections2277994int_erjections
intersection14610184inters_ection_
interspersions1663874interspersions
intraspecies1662804intraspec_i_es
introduction1555784intro_duction_
introgressions1572854introgressions
introjecting2254254intro_jecti_ng
introspect1474384introspect____
introspected1752844introspect__ed
introspectively2572214introspectively
introversions1663694intro_versions
retroflections1953874retroflections
retrospecting1863454retrospecti_ng
retrospectives2192784retrospectives
trisections1345644__tris_ections
circumspections2272255circumspections
entropions12105745entro_p___ions
incretions1248655incr___e_tions
incrustations15134285incrus_tations
indirections1556185in__directions
infections15510235in____fections
inflections1646985in___flections
infractions1646965infr___actions
injections1948665in____jections
insertions10410345in___s_ertions
inspecting1546225in___specti_ng
inspectors1444935in___spect_ors
instructions14137815instr___uctions
insurrections15104135in_surrections
intellection1466165int_ellection_
intentions10411405int____entions
interactions14410465int__eractions
interceptions1758185int_erceptions
interconnection1963125interconnection_
interdictions1667495int_erdictions
interjection2198925int_erjection_
interlineations1554545interlineations
interpositions1685125interpos__itions
interruptions1565735interrup__tions
intersecting1549715inters_ecti_ng
intersectional16146245inters_ectional
intersessions13195285inters_essions
interspecies1655095interspec_i_es
interspersion1564395interspersion_
interventions1657515int_erventions
intinctions1347005int___inctions
intonations1149525int_o__nations
intoxications22135685int_oxications
intraspecific22171525intraspec_ific
introgression1463055introgression_
introjects1953705intro_ject___s
intromissions15142795intro_missions
introversion1554085intro_version_
introverting1654275intro_verti_ng
intrusions1046335intrus____ions
projections2258475__pro_jections
prosecutions1645615__pros_ecutions
prospecting1845855__prospecti_ng
prospectors1754585__prospect_ors
protections15510705__pro_tections
reinspections1753095_reinspections
reintroductions1862155reintro_ductions
resections121513035___res_ections
retroactions1447075retro__actions
retrodictions1655535retro_dictions
retroflection1854045retroflection_
retrospective2083515retrospecti_ve
retrospects1562905retrospect___s
trajections2044515__tr_ajections
transections1446765__transections
transfections1854855__transfections
trisection1245985__tris_ection_

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.1261418182.5
2DLD Change Limit95024877.06313453.8
3Display Results87870.0601450.0
 (SQL Overall)178691877.24924650.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.