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

62 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
enamelers114480(None) 
enameler1045881enameler_
enamellers1242771enamellers
enablers10196912ena_blers
enameled1136372enamele_d
enameller1144172enameller_
enamels9128162enamel__s
nameless10248372_nameless
amblers115213563__amblers
ameers84015573__ame_ers
blameless1334733blameless
cameleers1345093_cameleers
cancelers13247863cancelers
decameters15156593decameters
dekameters17164863dekameters
diameters1247603diameters
dynameters1643793dynameters
emeers83314183e__me_ers
enabler9299363ena_bler_
enables92813123ena_ble_s
enamel81210113enamel___
enameling1246123enameling
enamelist1146943enamelist
enamelists1244563enamelists
enamelled1244623enamelled
enamelware1551523enamelware
enamelwares1651213enamelwares
enamines101112133enamine_s
enamors939123enam__ors
enamours1044663enam_ours
enfeeblers15151873enfeeblers
enfevers1444513en_fevers
ennoblers1143193ennoblers
enrollers976173enrollers
ensamples1343123ensample_s
entailers976413entailers
entanglers1163033entanglers
enterers82214153en_terers
examiners18124433examiners
examples1944313example_s
fameless13259203_fameless
flameless1435353flameless
frameless1435533frameless
gamblers13369733_gamblers
hexameters2244453hexameters
kneelers12226213kn_eelers
labelers10249413_labelers
nailers73215893_na_ilers
namers84517333_nam__ers
pentameters1544493pentameters
ramblers124010373_ramblers
ravelers113310863_ravelers
samplers12299403_samplers
shameless1435923shameless
snarlers8298753sna_rlers
snivelers1264533snivelers
tameless10259903_tameless
teaselers9165853teaselers
trammelers1442513trammelers
tramplers13305883tramplers
travelers12266773travelers
unreelers9154743unreelers

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 Filter1786911486410.423422437.4
2DLD Change Limit148641627.22020587.4
3Display Results62620.0302066.7
 (SQL Overall)178691627.67323288.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.