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

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

85 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
interventions165751(None) 
intervention1568381intervention_
interceptions1758182interceptions
interjections2277992interjections
intersections1598962intersections
interventionism2062372interventionism
interventionist1862902interventionist
innervations1546923innerv_ations
intellections1565383intellections
intentions10411403int___entions
interactions14410463inter_actions
interception1649393interception_
intercessions15225883intercessions
interdictions1667493interdictions
interjection2198923interjection_
interrelations1457613interrelations
interruptions1565733interruptions
intersection14610183intersection_
intersessions13195283intersessions
intervening1548173interven_i_ng
intervenors14105473interven__ors
inventions1348313in___ventions
superventions18125783superventions
contraventions19103574contraventions
enervations1478574en_erv_ations
imperfections2254004imperfections
inattentions1252604in_attentions
incretions1248654in_cr_e_tions
incurvations1746384incurv_ations
indentions1149064in___dentions
indirections1556194indir_ections
innervation1447444innerv_ation_
insertions10410344inser___tions
insurrections15104144insurrections
integrations13129474inte_grations
intellection1466164intellection_
intenerations1347464intenerations
intensions1048404int___ensions
intention9412014int___ention_
interaction13411814inter_action_
intercalations1655914intercalations
intercepting1748874intercepti_ng
interceptors16115734intercept_ors
intercession14226444intercession_
interdiction1568144interdiction_
interesting12411124inter_esti_ng
interferons1446744interfe__rons
interfusions1574394inter_fusions
interjecting2248394interjecti_ng
interjectional23195604interjectional
interjectors2155044interject_ors
interlending1456414interlendi_ng
interleukins1654144interleuki_ns
interlineations1554544interlineations
intermediations1894424intermediations
intermedins1447384interme_di_ns
interments12716214interment___s
intermissions1594144intermissions
interneurons1253824interne_urons
internuncios1452704internuncio_s
interpellations1774704interpellations
interpolations1657434interpolations
interpositions1685124interpositions
interpretations17134804interpretations
interrelation1358734interrelation_
interrogations1556814interrogations
interruption1466404interruption_
intersecting1549714intersecti_ng
intersectional16146254intersectional
intersession12175814intersession_
interspersions1663874interspersions
interstation12410414interstation_
interunion1046254inter_un_ion_
interveners14107304interven__ers
intervenes131012644interven___es
intervenor13106054interven__o_r
introjections2255784introjections
introversions1663694introversions
invention1248334in___vention_
iterations10413824i_ter__ations
nervations1359484_n_erv_ations
nonintervention1871494nonintervention_
preventions1648534_pre_ventions
supervention17105994supervention_
winterizations26157504winterizations

Search took 6 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 Limit95024855.53017183.4
3Display Results85850.0631349.2
 (SQL Overall)178691855.71931245.1
 
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.