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

47 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
glamoured134318(None) 
clamoured1444071clamoured
beglamoured1761472beglamoured
clamored1336942clamo_red
enamoured1243932enamoured
flavoured1642972flavoured
glamour1065132glamour__
glamourized2462172glamourized
glamours1184732glamour_s
laboured1156322_laboured
armoured1165223_armoured
beglamored1672233beglamo_red
belaboured1542273belaboured
clambered16146133clambered
clamorer1236903clamo_rer
clamour1196333clamour__
clamours1255993clamour_s
clangoured1441623clangoured
cloured103111543cl__oured
enamored1147033enamo_red
favoured1533963_favoured
flavored1554573flavo_red
floured11289873fl__oured
glaciered1343863glaciered
glaired9387743gla__ired
glamor958183glamo_r__
glamorised14104163glamorised
glamorized2384523glamorized
glamors1068113glamo_r_s
glamouring14113853glamouring
glamourize2262423glamourize
glamourizes2362423glamourizes
glamourless1451333glamourless
glamourous1352353glamourous
glandered1236333glandered
glared84715193gla___red
glimmered1543103glimmered
glouted9429713gl__outed
humoured1444363_humoured
labored102810243_labo_red
labourer1045753_labourer
loured74617403_l__oured
rumoured1143783_rumoured
savoured1234793_savoured
taboured1156273_taboured
tamboured1443783_tamboured
vapoured1434353_vapoured

Search took 7 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.420425454.8
2DLD Change Limit148641476.51622811.7
3Display Results47470.0133615.4
 (SQL Overall)178691476.94925714.6
 
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.