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

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
interspersions166387(None) 
interspersion1564391interspersion_
intersessions13195282inters_essions
interspersing1654482interspersi_ng
intercessions15225883inter_cessions
intersections1598963inters_ections
intersession12175813inters_ession_
intersperses1454753interspers__es
introversions1663693int_roversions
interceptions1758184inter_ceptions
intercession14226444inter_cession_
interferons1446744inter_fer__ons
interfusions1574394inter__fusions
interjections2277994inter_jections
intermissions1594144inter_missions
interpersonal1564024inter_pers_onal
intersection14610184inters_ection_
interspecies1655094interspe_ci_es
intersperse1354964interspers___e
interspersed1553654interspers__ed
interventions1657514inter_ventions
introspections1864064introspections
introversion1554084int_roversion_
newspersons1652304_n_ewspers_ons
aspersions1246105____aspersions
camerapersons1971245camerapers_ons
dispersions1446455___dispersions
extraversions2382335ext_raversions
extroversions2382155ext_roversions
ingressions1245495in_gr__essions
innerspring1452655innersp_r_i_ng
insertions10410345in___s_ertions
inspections1546425in___spections
intellections1565395inte_llections
intenerations1347465inte__nerations
intensions1048405int____ensions
interactions14410465inter__actions
intercalations1655915intercalations
interception1649395inter_ception_
intercessional1663645inter_cessional
intercessors1453885inter_ce_ssors
interconversion2072485interconversion_
interdictions1667495inter_dictions
interdiffusions22131885interdiffusions
interfering1558925inter_fer_i_ng
interferon1346845inter_fer__on_
interfusion1464985inter__fusion_
interjection2198925inter_jection_
interleukins1654145inter_leuki_ns
interlineations1554545interlineations
intermedins1447385inter_me_di_ns
intermission1464655inter_mission_
interneurons1253825inter_ne_urons
interpellations1774705inter_pellations
interpolations1657435interpolations
interposing1447805inter_p_osi_ng
interpositions1685125interpositions
interpretations17134805interpretations
interpreting1588305inter_preti_ng
interrelations1457615interrelations
interrogations1556815interrogations
interruptions1565735inter_ruptions
intersecting1549715inters_ecti_ng
intersectional16146255inters_ectional
intersensory1552755inters_ens_ory
interservice1754075inters_ervi_ce
interspacing1755055intersp_aci_ng
interspecific2261945interspe_cific
interstation12410415inters_tation_
intersterile1254285interster_i_le
interstrain1155865inters_trai_n_
intervention1568385inter_vention_
intrapersonal1572885int_rapers_onal
introgressions1572855introgressions
introjections2255785int_rojections
intromissions15142795int_romissions
introspection1764625introspection_
intrusions1046335int_r___usions
inversions1347005in____versions
newsperson1552495_n_ewspers_on_
perversions1645415__per_versions
retroversions1673455ret_roversions
salespersons1461915sale_spers_ons
superpersons1654625super_pers_ons
supersessions1454775supers_essions

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.346516448.0
2DLD Change Limit95024856.64014310.8
3Display Results85850.0461847.8
 (SQL Overall)178691857.03225411.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.