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

67 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
intermarriage166216(None) 
intermarriages1761591intermarriages
intermarried1553633intermarri_ed
intermarries1454853intermarri_es
intermarrying1962283intermarrying_
undercarriage1761433undercarriage
interlarding1445564interlarding_
intermarginal1672904intermarginal
intermarry1564154intermarr___y
intermatting1547174intermatting_
intermediate1554814interm_ediate
interparticle17132624interparticle
premarriage1652024_pre_marriage
remarriage1362354__re_marriage
undercarriages1861244undercarriages
intemperate1555775inte_mper_ate
interacting14411715inter_acting_
interactive1659635inter_acti_ve
interage9314485inte____r_age
interarching1845015inter_arching_
intercalate13117705interca__late
intercorrelate16142555intercorrelate
interfacial1656295interfa_cia_l
interfacing1747705interfa_cing_
interfacings1854355interfa_cings
interfering1558925inter_fering_
interfertile1556425interferti_le
intergrade1247365inter__gr_ade
intergrading1545985intergrading_
interiorise1148095inter_iori_se
interiorize2056335inter_iori_ze
interlacing1449055interla_cing_
interlapping1754035interlapping_
interlayering1753055interlayering_
interlaying1547575interla_ying_
intermale11712295interm____ale
intermediacy20143055interm_ediacy
intermediary18133565interm_ediary
intermediated1753825interm_ediated
intermediates1654345interm_ediates
intermembrane1961745intermembrane
intermeshing1855055intermeshing_
intermingle1445765interm___ingle
intermitting1547255intermitting_
intermixing2146615interm_ixing_
intermontane1464565interm_ontane
internalise111510555interna_li_se
internalize20149595interna_li_ze
interparish1655585interpa_ri_sh
interpermeate1754235interpermeate
interrace11312545inte___rr_ace
interracial1357075interra_cia_l
interrelate11188975inter__relate
interring10315425inte___rring_
interrogate1277615inter__rogate
interservice1754065interservi_ce
interstage1176405inte___rstage
intersterile1254285intersteri_le
intertillage1352505inter_tillage
intertrial1049515inter__tria_l
intervillage1652235inter_village
interworking2054525interworking_
interworkings2152485interworkings
marriage1147255_____marriage
mismarriage1681605__mismarriage
remarriages1452205__re_marriages
watermarking2252685watermarking_

Search took 10 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 Filter1786911247900.1401276364.3
2DLD Change Limit124790679.47013177.4
3Display Results67670.0461456.5
 (SQL Overall)178691679.65618505.7
 
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.