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

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
interspersion156439(None) 
interspersions1663871interspersions
intersession12175812inters_ession
interspersing1654482interspersing
intercession14226443inter_cession
intersection14610183inters_ection
intersessions13195283inters_essions
intersperse1354963interspers__e
interspersed1553653interspers_ed
intersperses1454753interspers_es
introversion1554083int_roversion
interception1649394inter_ception
intercessions15225884inter_cessions
interconversion2072484interconversion
interferon1346854inter_fer__on
interfusion1464984inter__fusion
interjection2198924inter_jection
intermission1464654inter_mission
interpersonal1564024inter_pers_onal
intersections1598964inters_ections
interservice1754074inters_ervice
interspecies1655094interspe_cies
interstation12410414inters_tation
intersterile1254284interster_ile
interstrain1155864inters_trai_n
intervention1568384inter_vention
introspection1764624introspection
introversions1663694int_roversions
newsperson1552504_n_ewspers_on
antirecession1562675antirecession
aspersion1146165____aspersion
cameraperson1861335camerapers_on
dispersion1346865___dispersion
extraversion2272655ext_raversion
extroversion2282285ext_roversion
ingression1145515in_gr__ession
innerspring1452655innersp_r_ing
insertion9410595in___s_ertion
inspection1446665in___spection
intellection1466175inte_llection
inteneration1248625inte__neration
intension948495int____ension
interaction13411815inter__action
interbasin1246855inter__basi_n
intercalation1557085intercalation
interceptions1758185inter_ceptions
intercessional1663645inter_cessional
intercessor1354335inter_ce_ssor
intercomparison2171225intercomparison
interdiction1568145inter_diction
interdiffusion21132075interdiffusion
interdominion1662635interdominion
interelectron1564135interelectron
interfering1558925inter_fer_ing
interferons1446745inter_fer__ons
interfertile1556425inter_fertile
interfusions1574395inter__fusions
intergeneration1673395intergeneration
interjections2277995inter_jections
interleukin1554455inter_leuki_n
interlineation1455405interlineation
interlopers1346195interlopers___
intermedin1347445inter_me_di_n
intermissions1594145inter_missions
interneuron1154075inter_ne_uron
interoperable1763575interoperable
interoperative1974365interoperative
interparish1655585inter_par_ish
interpellation1665615inter_pellation
interpolation1558555interpolation
interposing1447805inter_p_osing
interposition1586055interposition
interpretation16115865interpretation
interpreting1588305inter_preting
interpretive1775845inter_pretive
interrelation1358735interrelation
interrogation1457865interrogation
interruption1466405inter_ruption
intersecting1549715inters_ecting
intersectional16146255inters_ectional
intersensory1552755inters_ensory
interspacing1755055intersp_acing
interspecific2261945interspecific
intersterility1762505intersterility
interunion1046255inter___union
interventions1657515inter_ventions
intrapersonal1572885int_rapers_onal
introgression1463055introgression
introjection2156205int_rojection
intromission14143205int_romission
introspections1864065introspections
introversive1863215int_roversive
intrusion946815int_r___usion
inversion1247215in____version
newspersons1652305_n_ewspers_ons
perversion1545855__per_version
retroversion1573675ret_roversion
salesperson1351915sale_spers_on
superperson1554605super_pers_on
supersession1454845supers_ession

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901008.73614284.6
3Display Results1001000.0601666.7
 (SQL Overall)1786911009.18619452.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.