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

102 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
enamored114703(None) 
enamoured1243931enamoured
clamored1336942clamored
coenamored1562632coenamored
enameled1136372enameled
enamor838752enamor__
enamors939122enamor_s
encored10412102en_cored
unarmored1244872unarmored
adored84714243__adored
anchored1438593anchored
anymore1256243anymore_
armored102610473_armored
beclamored1752143beclamored
beglamored1672233beglamored
belabored1443813belabored
benamed122911093benam__ed
censored11197953cen_sored
clamorer1236903clamorer
clamoured1444073clamoured
denatured1146023denatured
eared65139503e_a__red
emoted94614923e__moted
enabled102510633ena_bled
enacted10310643ena_cted
enamel81210113enam__el
enameler1045883enameler
enamelled1244613enamelled
enamine91214313enamine_
enamines101112133enamines
enamoring1247033enamoring
enamour945433enamo_ur
enamours1044663enamours
encamped1535023encam_ped
enclosed1198253enclosed
encoded1139033en_coded
encore8314773en_core_
encores9315213en_cores
endamaged1442773endamaged
endeared1038053endeared
endeavored1552143endeavored
endorsed1057193en_dorsed
endowed1248173en_dowed
endured93611213en_dured
enforced14216743en_forced
engorged1134553en_gorged
enhaloed12125933enhalo_ed
enjambed2042823enjam_bed
enjoyed1834523en_joyed
enquired18255793enquired
enrobed10279253en_robed
enrooted977423enrooted
ensnared965293ensnared
ensured83512943en_sured
entered82718883en_tered
entombed13104503entombed
enured73315333en__ured
enwombed16122943enwombed
examined18135863examined
exampled2043353exampled
explored1845083explored
favored1455983_favored
flavored1554573flavored
glamoured1343183glamoured
gnarred9327003gna_rred
humored1336723_humored
knarred12266003kna_rred
labored102810243_labored
majored1735853_majored
mentored1138003men_tored
nacred95212493_na_cred
named85223063_nam__ed
natured838963_natured
neared75119803nea__red
pinafored1543223pinafored
rancored1137223rancored
razored1736333_razored
renamed103114523renam__ed
renatured1047283renatured
rumored1046643_rumored
samoyed1335893_samoyed
savored1158343_savored
shamoyed1744043shamoyed
snared74824553sna__red
snored74819543sn__ored
tabored102810563_tabored
unaborted1245733unaborted
unadmired1343863unadmired
unadorned1144123unadorned
unaired82916013una_ired
unamazed2035883unamazed
unamused1135793unamused
unatoned939423unatoned
unavowed1534783unavowed
unfavored1643443unfavored
unlabored1243803unlabored
unmarred11258403unmarred
unmoored1137333unmoored
unmoved13248903un_moved
unsmoked1536013unsmoked
vamosed1335923_vamosed
vapored1336923_vapored

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.420425454.8
2DLD Change Limit1461621026.98620922.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.45223978.9
 
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.