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

37 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
interprovincial227106(None) 
interproximal2461864interproxi__mal
intertropical1762734intertropi_c_al
intercolonial1563975inter_colon_ial
intercortical1764425intercorti_c_al
internuncial1453445inte__r_nuncial
interparochial21111675interparo__chial
interpluvial1752835interpluv___ial
interracial1357075inter_r___acial
provincial1754015_____provincial
enteroviral1452816ente__rovi__ral
interdominion1662636inter_domin_ion
interfacial1656296inte__r__facial
interfamilial1862746inter_fami_lial
interferential1763976inter_ferential
interfluvial1852676interfluv___ial
interglacial1554036inte__r_glacial
interjoining2054656inter_jo_in_ing
interlocal1247096inter_lo___c_al
intermarginal1672906intermargin__al
interorbital1453626interor_bi__tal
interparoxysmal2911736interparo_xysmal
interpersonal1564026interperson__al
interphalangeal21121066interphalangeal
interpoint12411886interp_o_in___t
interposing1447806interp_osin___g
interposition1586056interp_osi_tion
interpreting1588306interpretin___g
interregional1453766inter_regi_onal
interrenal1049826inter_r__en__al
intersocietal1562416inter_soci_etal
interstitial1255636inte__rsti_tial
interterminal1554306intertermin__al
intertrial1049526intertr_____ial
intertribal1354686intertr__i__bal
interzonal1946816inter_zo__n__al
provincials1852946_____provincials

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.360496363.9
2DLD Change Limit95024378.37311348.9
3Display Results37370.0331121.2
 (SQL Overall)178691378.76620384.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.