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

43 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
intermarriages176159(None) 
intermarriage1662171intermarriage_
intermarries1454862intermarri__es
intermarried1553643intermarri__ed
undercarriages1861243undercarriages
intermarrying1962284intermarrying__
intermediates1654344interm_ediates
remarriages1452204__re_marriages
undercarriage1761444undercarriage_
infirmaries1652995infirma_ri__es
interarches1645925inter_a_r_ches
intercalates14117265interca__lates
intercorrelates17162065intercorrelates
interfacings1854355interfa_cing_s
intergrades1346785inter__gr_ades
interiorises1296885inter_iori_ses
interiorities1356705inter_iorities
interiorizes2155695inter_iori_zes
interlarding1445565interlarding__
intermarginal1672905intermargi_nal
intermarry1564155intermarr____y
intermatting1547175intermatting__
intermediacies19102335interm_ediacies
intermediaries1782525interm_ediaries
intermediate1554815interm_ediate_
intermediated1753825interm_ediated
intermingles1574395interm___ingles
intermixes1948395interm___i_xes
internalises12149115interna_li_ses
internalities1358635interna_lities
internalizes21138695interna_li_zes
interparticle17132625interparticle_
interpermeates1863465interpermeates
interreges1148845inte___rr_eges
interrelates12148075inter__relates
interrogates1387105inter__rogates
intertillages1452225inter_tillages
interworkings2152485interworking_s
marriages1247385_____marriages
mismarriages1791415__mismarriages
premarriage1652035_pre_marriage_
remarriage1362365__re_marriage_
winterberries1892015winterberri__es

Search took 8 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 Limit95024436.62614341.1
3Display Results43430.0301433.3
 (SQL Overall)178691437.01625469.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.