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

98 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
glamours118473(None) 
clamours1255991clamours
glamors1068111glamo_rs
glamour1065131glamour_
amours83512662__amours
beglamours1591832beglamours
clamors11710092clamo_rs
clamour1196332clamour_
enamours1044662enamours
flavours1434692flavours
giaours834572gia_ours
glamor958182glamo_r_
glamoured1343182glamoured
glamourous1352352glamourous
labours9349892_labours
agamous1037943agamou_s
alamodes1148013alamodes
alamos8415003alamo__s
amour75014853__amour_
armours9389853_armours
beglamors1473373beglamo_rs
beglamour1491953beglamour_
belabours1343543belabours
blamers115314213blam_ers
clambers144211293clambers
clammers143510693clammers
clamor1049453clamo_r_
clamorers1345783clamorers
clamoured1444073clamoured
clampers143211893clampers
clangours12263123clangours
clours85215093cl__ours
enamors939123enamo_rs
enamour945433enamour_
famous11412393_famou_s
favours13437093_favours
flameouts1443923flameouts
flamers124616363flam_ers
flaneurs1133953flaneurs
flavors1337293flavo_rs
flavour1334633flavour_
flavoury1743063flavoury
flours94414053fl__ours
gallous82813953gallou_s
gambirs12359083g_ambirs
gamers94420833g_am_ers
gammers123214563g_ammers
gamuts958783g_am_uts
gators74115833g_ato_rs
gaurs66317993g_a__urs
giaour735363gia_our_
glabrous1145533glabrou_s
glaciers11277893glaciers
glairs75211333gla__irs
glamorise1295913glamorise
glamorous1245093glamorous
glamouring14113853glamouring
glamourize2262423glamourize
glamourizes2362423glamourizes
glamourless1451333glamourless
glams85822933glam___s
glancers11408003glancers
glanders103811503glanders
glaucous1144223glaucou_s
glazers174410043gla_zers
glaziers18406563glaziers
gleamers11306563gleam_ers
glimmers13396153glimmers
globous1036503globou_s
glomus9468093glom_u_s
glouts74414713gl__outs
grammars13345943grammars
grampus12356313grampu_s
grayouts1244693grayouts
grumous1086613grumou_s
gummous1236263gummou_s
humours1286433_humours
labors84016413_labo_rs
labour84210933_labour_
lambers113817113_lambers
lampers113817333_lampers
langurs889103_langurs
layouts1046483_layouts
lemurs837253_lem_urs
lours55125293_l__ours
paramours1345653paramours
ramous8417113_ramou_s
rumours976373_rumours
samburs11369343_samburs
sapours93610623_sapours
savours10389343_savours
slammers123511223slammers
tabours94110093_tabours
tambours1255873_tambours
tamburs11288613_tamburs
tumours976753_tumours
valours10248743_valours
vapours12277463_vapours

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.406440125.6
2DLD Change Limit146162986.67021913.3
3Display Results98980.0332969.7
 (SQL Overall)178691987.10925135.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.