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

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

84 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
interfacial165629(None) 
interracial1357071interracial
interfacing1747702interfacing
interglacial1554032interglacial
interface14410173interfac__e
interfaced1647943interfac_ed
interfaces15410413interfac_es
interfacings1854353interfacings
interfaith1645923interfa_ith
interfamilial1862743interfamilial
interfamily1953983interfamily
interfluvial1852673interfluvial
interglacials1662553interglacials
interlacing1449053interlacing
interlocal1247093interloc_al
internuncial1453443internuncial
interracially1863633interracially
interstadial1354083interstadial
intertrial1049513inter_trial
icterical1347214icter_ic_al
inertial8411724in_er__tial
inferential1457544inferential
interact10316474inter_ac__t
interactant1357044inter_actant
interacted13411214inter_acted
interacting14411714inter_acting
interaction13411814inter_action
interactional1557004inter_actional
interactive1659634inter_active
interacts11312124inter_ac_ts
interannual1154374interannual
interbasin1246854interbasi_n
intercell1148164inter__cell
intercensal1356144intercensal
intercity14410004inter__city
interclan1148604inter__clan
intercoastal1463984intercoastal
intercostal1365764intercostal
interdental1258414interdental
interfaculty2052384interfaculty
interfering1558924interfering
interfile12411044interf__ile
interfiling1546954interfiling
interfirm1446444interf__irm
interfusing1555834interfusing
interfusion1464984interfusion
interlace11311914interlac__e
interlaced1349234interlac_ed
interlaces12412054interlac_es
interlaid1049354interla_i_d
interlaminar1453524interlaminar
interlaying1547574interlaying
intermarginal1672904intermarginal
intermodal1346184inter_modal
internal8414084inter___nal
internalise111510554internalise
internality1448684internality
internalize20149594internalize
international1357674international
internecine1367874internecine
internodal1145874inter_nodal
interocean1246484inter_ocean
interorbital1453624interorbital
interparish1655584interparish
interparochial21111674interparochial
interpluvial1752834interpluvial
interrace11312554interrac__e
interrenal1049814inter_renal
intersexual1854704intersexual
intersocietal1562414intersocietal
interspacing1755054interspacing
interstadials1462534interstadials
interstitial1255634interstitial
intertidal1147714inter_tidal
intertill9410424inter__till
intertribal1354684intertribal
interval11710464inter___val
interzonal1946814inter_zonal
intestacies1355304intestacies
intracity1448424int_r_acity
intravital1354824int_r_avital
nonracial1148104_nonr_acial
superficial1854404superficial
trifacial1444694__trifacial

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 Filter1786911488190.423422437.4
2DLD Change Limit148819849.06016425.9
3Display Results84840.0461826.1
 (SQL Overall)178691849.52918752.3
 
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.