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

65 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
enamour94543(None) 
enamor838751enamo_r
enamours1044661enamours
amour75014852__amour
clamour1196332clamour
enamors939122enamors
enamoured1243932enamoured
glamour1065132glamour
agamous1037943agamous
amours83512663__amours
armour84411853_armour
beglamour1491953beglamour
belabour1243773belabour
candour104210243candour
clamor1049453clamo_r
clamours1255993clamours
coenamor1244803coenamo_r
ecotour944363ecotour
enabler9299363enabler
enactor938033enactor
enamel81210113enam_el
enameler1045883enameler
enamels9128163enamels
enamine91214313enamine
enamored1147033enamored
enamouring1344293enamouring
endeavour1351973endeavour
endmost1056763endmost
enormous1046553enormous
ensoul638253en_soul
envious1037223envious
famous11412393_famous
favour12438333_favour
flavour1334633flavour
giaour735363gia_our
glamor958183glamo_r
glamours1184733glamours
humour11116753_humour
infamous1354543infamous
inpour837063in_pour
knaur9508253kna__ur
labour84210933_labour
namer75622103_nam_er
pandour10408213pandour
paramour1246083paramour
ramous8417113_ramous
rancour987133rancour
rumour8127383_rumour
sambur10469503_sambur
santour737373santour
sapour83812373_sapour
savour94110703_savour
senator7313063senato_r
tabour84011323_tabour
tambour1136353_tambour
tambur10358713_tambur
tenour62610733ten__our
tinamou965013tinamou_
tinamous1045983tinamous
tumour8137403_tumour
unfamous1344293unfamous
unmoor836313un_moor
valour93010373_valour
vapour11378873_vapour
venomous1345163venomous

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 Filter1786911340270.1401276364.3
2DLD Change Limit134027657.09618887.7
3Display Results65650.0302166.7
 (SQL Overall)178691657.26624592.8
 
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.