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

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

56 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
intercomparison217122(None) 
intercompares19133203intercompares__
intercomparing2162283intercompari_ng
intercommunion2071884intercommuni_on
intercompare18103524intercompar___e
intercompared20122564intercompar__ed
interconversion2072484interconversion
comparison1644355_____comparison
intercalation1557085interc_alati_on
interception1649395interc_ep_ti_on
intercommunions2171635intercommuni_ons
intercompany21112615intercompa___ny
interdominion1662635interdom_ini_on
interparish1655585inter___paris_h
interpolation1558555interpo_lati_on
interrogation1457865interro_gati_on
interspersion1564395inter__spersion
comparisons1753976_____comparisons
interanimation16136016interanimati_on
intercalations1655916interc_alati_ons
intercampus1752586intercamp__us__
interceptions1758186interc_ep_ti_ons
intercession14226446interc__essi_on
interchain1546636interc__ha_i__n
intercommunity2381846intercommuni_ty
intercoms1349336intercom____s__
interconnection1963126interconnection
interconverts1853106interconverts__
intercoolers1454456intercooler_s__
intercorporate18132806intercorpor_ate
intercostals1454606intercosta_ls__
intercourse1355016interco__ur_s_e
intercourses1454596interco__ur_ses
intergradation16114096intergradati_on
interiorise1148096interio___ris_e
interiorised1355186interio___rised
interiorises1296886interio___rises
interiorising14144916interio___rising
interiorization2464786interiorizati_on
interlineation1455406interlineati_on
interlopers1346196interlo_per_s__
intermediation17105216intermediati_on
intermission1464656inter__missi_on
intermodulation1893066intermodulati_on
interpellation1665616interpellati_on
interpolations1657436interpo_lati_ons
interpopulation1963596interpopulati_on
interposition1586056interpo_siti_on
interpretation16115866interpretati_on
interrelation1358736inter_relati_on
interrogations1556816interro_gati_ons
interruption1466406inter_rup_ti_on
interspersions1663876inter__spersions
interstation12410416inter__stati_on
intromission14143206int_r_omissi_on
introversion1554086int_r_o_version

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.1231452772.4
2DLD Change Limit95024568.56311097.0
3Display Results56560.0301866.7
 (SQL Overall)178691568.71620501.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.