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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
internal841408(None) 
infernal1186821infernal
internals9712721internals
interval11710451interval
antennal856352antennal
asternal858322asternal
cisternal11325742cisternal
enteral73516442enter_al
eternal72910892_eternal
external1577222external
integral946782integral
interlap1048592interlap
interlay11310042interlay
intermale11712292intermale
intermat101114612intermat
intern64016542intern__
internally13410092internally
interne73218142intern_e
interned93016652interned
internee82718512internee
internes82721232internes
internodal1145872internodal
interns73116772intern_s
interrenal1049812interrenal
intervale12911582intervale
intervals12810132intervals
interwar1148262interwar
interzonal1946812interzonal
inthral10249462inthr_al
maternal1047802maternal
paternal1038332paternal
sternal73411912_sternal
antenna746383antenna_
antennae845453antennae
antennas846403antennas
antheral1149393anther_al
antral65719413ant_r_al
apteral9311523apter_al
arterial8313633arterial
cisterna10376363cisterna_
cisternae11265093cisternae
coeternal1144303coeternal
dipteral1147003dipter_al
entera64216833enter_a_
enthral103410933enthr_al
eternals8238953_eternals
externals1666623externals
fingernail1451683fingernail
fraternal1243873fraternal
hibernal1344403hibernal
icterical1347213icterical
imperial1249023imperial
inertial8411723in_ertial
infaunal1143823infaunal
infernally1645263infernally
inferno1045603infern_o
infernos1145903infernos
informal1355643informal
inguinal945603inguinal
integrals1046463integrals
integrand1145033integrand
integrant1049833integrant
intend72310373inte_n_d
intends8239963inte_nds
intense72511903inte_nse
intent63122773inte_n_t
intently1149823inte_ntly
intents72115703inte_nts
inter55028493inter___
interact10316463interact
interage9314483interage
interannual1154373interannual
interbank1547033interbank
interbed112413103interbed
intercell1148163intercell
intercensal1356143intercensal
interclan1148603interclan
intercom1248683intercom
intercut10411113intercut
interdental1258413interdental
interest8319183interest
interface14410163interface
interfile12411043interfile
interfold13137483interfold
intergang11117883intergang
interim9912873inter_im
interims101013073interims
interior8513093interior
interknit1358333interknit
interknot1356903interknot
interlace11311903interlace
interlaid1049353interlaid
interlaps1148233interlaps
interlard1048453interlard
interlays1248083interlays
interleaf1248043interleaf
interloan948773interloan
interlocal1247093interlocal
interlunar1045433interlunar
intermats111412453intermats
intermit101213593intermit
intermix17156873intermix
intermodal1346183intermodal
internalise111510553internalise
internality1448683internality
internalize20149593internalize
internees93014843internees
interning10315253interning
internist9414883internist
internode1048763internode
interplay1447163interplay
interrace11312543interrace
interred92615263interred
interrex15249823interrex
interrow1147133interrow
inters64328053inter__s
intersex15209733intersex
intertidal1147713intertidal
intertie8317613intertie
intertill9410423intertill
intertrial1049513intertrial
interunit959833interunit
intervales131010503intervales
intestinal1047513intestinal
inthrall11247063inthrall
inthrals11258503inthr_als
intimal9109943int_imal
intrant7318753int_rant
intreat7416303int_reat
intrench1396593intrench
inturn63411563inturn__
inturned9268313inturned
inturns73210133inturn_s
iterant7317783i_terant
lateral7313573later_al
literal7613273liter_al
material10314103material
mineral9312733min_er_al
sterna63712763_sterna_
supernal1039873supernal
tarnal63716503__tarnal
tergal72912833__tergal
vernal93514213__vernal

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621436.93621073.0
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.15524974.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.