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

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

92 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
intercomparison2171221intercomparison_
intercomparing2162283intercompari__ng
intercompares19133204intercompares___
intercommunion2071885intercommuni_on_
intercommunions2171635intercommuni_ons
intercompany21112615intercompa____ny
intercompare18103525intercompar____e
intercompared20122565intercompar___ed
interconversion2072485interconversion_
comparison1644356_____comparison_
comparisons1753976_____comparisons
intercalation1557086interc_alati_on_
intercalations1655916interc_alati_ons
interception1649396interc_ep_ti_on_
interceptions1758186interc_ep_ti_ons
interdominion1662636interdom_ini_on_
interiorising14144916interio___rising
interparish1655586inter___paris__h
interpersonal1564026inter___per_sonal
interpolation1558556interpo_lati_on_
interpolations1657436interpo_lati_ons
interrogation1457866interro_gati_on_
interrogational1693906interro_gati_onal
interrogations1556816interro_gati_ons
interspersion1564396inter__spersion_
interspersions1663876inter__spersions
enterprising1554087enter___p_rising
interanimation16136017interanimati_on_
interanimations17115197interanimati_ons
intercalating1656507interc_alati__ng
intercampus1752587intercamp__us___
intercepting1748877interc_ep_ti__ng
intercession14226447interc__essi_on_
intercessional1663647interc__essi_onal
intercessions15225887interc__essi_ons
interchain1546637interc__ha_i__n_
intercoastal1463987interco__a__stal
intercommunal1962557intercom____munal
intercommunity2381847intercommuni__ty
intercoms1349337intercom____s___
interconnection1963127interconnection_
interconverting21132597interconver_ting
interconverts1853107interconverts___
intercoolers1454457intercooler_s___
intercorporate18132807intercorpor__ate
intercostals1454607intercosta_ls___
intercourse1355017interco__ur_s__e
intercourses1454597interco__ur_s_es
intercropping2052807intercrop_pi__ng
intergradation16114097intergradati_on_
intergradations17123457intergradati_ons
interiorise1148097interio___ris__e
interiorised1355187interio___ris_ed
interiorises1296887interio___ris_es
interiorization2464787interiorizati_on_
interiorizing23144977interio___rizing
interlineation1455407interlineati_on_
interlineations1554547interlineati_ons
interlooping1554317interloop__i__ng
interlopers1346197interlo_per_s___
interloping1446967interlo_p__i__ng
intermarginal1672907inter__m_ar_ginal
intermarrying1962287inter__m_arrying
intermediation17105217intermediati_on_
intermediations1894427intermediati_ons
intermission1464657inter__missi_on_
intermissions1594147inter__missi_ons
intermodulation1893067intermodulati_on_
internalising1455627inter___nalising
international1357677inter___nati_onal
interpellation1665617interpellati_on_
interpellations1774707interpellati_ons
interpolating1657797interpo_lati__ng
interpopulation1963597interpopulati_on_
interposition1586057interpo_siti_on_
interpositions1685127interpo_siti_ons
interpretation16115867interpretati_on_
interpretations17134807interpretati_ons
interrelation1358737inter_relati_on_
interrelations1457617inter_relati_ons
interrogating1556667interro_gati__ng
interruption1466407inter_rup_ti_on_
interruptions1565737inter_rup_ti_ons
interspacing1755057inter__spaci__ng
interspersing1654487inter__sper_sing
interstation12410417inter__stati_on_
intracompany2161537intracompa____ny
intrapersonal1572887int_r__aper_sonal
intromission14143207int_r_omissi_on_
intromissions15142797int_r_omissi_ons
introversion1554087int_r_o_version_
introversions1663697int_r_o_versions

Search took 9 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.343520965.0
2DLD Change Limit95024928.54611119.1
3Display Results92920.0761210.5
 (SQL Overall)178691928.96519932.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.