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

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

57 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
external157722(None) 
eternal72910891e_ternal
externals1666621externals
asternal858322asternal
enteral73516452enter_al
eternals8238952e_ternals
extern1348472extern__
externally2045542externally
externe1438572extern_e
externes1539832externes
externs1438232extern_s
internal8414092internal
maternal1047802maternal
paternal1038332paternal
sternal73411912_sternal
antennal856353antennal
apteral9311523apter_al
arterial8313653arterial
cisternal11325743cisternal
coeternal1144303coeternal
dextral1577003dext_r_al
entera64216833enter_a_
enthral103410933enthr_al
estral64716513est_r_al
estrual7367933est_rual
eternally1247493e_ternally
eterne6311723e_tern_e
ethereal1146783ethereal
excretal1764353excretal
exergual1642443ex_ergual
exothermal2273343exothermal
extend14267523exte_n_d
extends15227113exte_nds
extent132714913exte_n_t
extents142610173exte_nts
exterior1547393exterior
externalise1856083externalise
externalism2055933externalism
externality2155043externality
externalize2756383externalize
extra1239003ext_r_a_
extras13310223ext_r_as
extrema1675013extrema_
fraternal1243873fraternal
hibernal1344413hibernal
infernal1186833infernal
internals9712733internals
interval11710473interval
lateral7313573later_al
literal7613273liter_al
material10314113material
sterna63712763_sterna_
supernal1039873supernal
tarnal63716503__tarnal
tergal72912833__tergal
textural1544943textur_al
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.423422437.4
2DLD Change Limit146162577.50019488.3
3Display Results57570.0163562.5
 (SQL Overall)178691577.93922508.0
 
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.