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

44 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
interprovincial2271061interprovincial_
interproximal2461865interproxi__mal_
intertropical1762735intertropi_c_al_
intercolonial1563986inter_colon_ial_
intercortical1764426intercorti_c_al_
internuncial1453446inte__r_nuncial_
interparochial21111676interparo__chial_
interpluvial1752836interpluv___ial_
interracial1357076inter_r___acial_
provincial1754016_____provincial_
provincials1852946_____provincials
enteroviral1452817ente__rovi__ral_
interdominion1662637inter_domin_i_on
interfacial1656297inte__r__facial_
interfamilial1862747inter_fami_lial_
interferential1763977inter_ferential_
interfluvial1852677interfluv___ial_
interglacial1554037inte__r_glacial_
interglacials1662557inte__r_glacials
interjoining2054657inter_jo_in_i_ng
interlocal1247097inter_lo___c_al_
intermarginal1672907intermargin__al_
interorbital1453627interor_bi__tal_
interparoxysmal2911737interparo_xysmal_
interparticle17132627interparti_c__le
interpersonal1564027interperson__al_
interphalangeal21121067interphalangeal_
interpoint12411887interp_o_in____t
interposing1447807interp_osin____g
interposition1586057interp_osi_ti_on
interpositions1685127interp_osi_tions
interpreting1588307interpretin____g
interpretively2262937interpreti__vely
interracially1863637inter_r___acially
interregional1453767inter_regi_onal_
interrenal1049827inter_r__en__al_
intersocietal1562417inter_soci_etal_
interstitial1255637inte__rsti_tial_
interterminal1554307intertermin__al_
intertrial1049527intertr_____ial_
intertribal1354687intertr__i__bal_
intervisible1753927inte__r_vi_sible
interzonal1946817inter_zo__n__al_
provincially2253027_____provincially

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 Limit95024448.22011560.1
3Display Results44440.0301466.7
 (SQL Overall)178691448.61020753.9
 
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.