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

132 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
clamours125599(None) 
clamors11710091clamo_rs
clamour1196331clamour_
glamours1184731glamours
amours83512662__amours
clambers144211292clambers
clammers143510692clammers
clamor1049452clamo_r_
clamorers1345782clamorers
clamoured1444072clamoured
clampers143211892clampers
clangours12263122clangours
clours85215092cl__ours
enamours1044662enamours
flavours1434692flavours
glamors1068112glamo_rs
glamour1065132glamour_
labours9349892_labours
agamous1037943agamou_s
alamodes1148013alamodes
alamos8415003alamo__s
amour75014853__amour_
armours9389853_armours
beclamors1574223beclamo_rs
beglamours1591833beglamours
belabours1343543belabours
blamers115314213blam_ers
calamars1238133calam_ars
calamus1139243calam_u_s
callous93516603callou_s
cambers134017443c_ambers
camorra11115763c_amorra
camorras12116503c_amorras
camos95927613c_amo__s
campers134220293c_ampers
campouts1436823c_ampouts
campus125213923c_ampu_s
candours11408643candours
canoers94318373c_anoers
chabouks1943823chabouks
chadors1338753chado_rs
chambers173410623chambers
chamfers18409223chamfers
chamois143512193chamo_is
champers173311623champers
chymous1775703chymou_s
clabbers14359903clabbers
clackers163911703clackers
cladodes1245323cladodes
clafouti1342913clafouti
clafoutis1442233clafoutis
claimers12298743claimers
clamber133311743clamber_
clammer134211793clammer_
clamored1336943clamored
clamorer1236903clamorer
clamorous1346193clamorous
clamouring15104773clamouring
clamper134012993clamper_
clamps124515083clam__ps
clams95127673clam___s
clamworm1744203clamworm
clamworms1843753clamworms
clangers114312343clangers
clangors11417003clangors
clangour11293803clangour_
clappers143310833clappers
claquers19226203claquers
claques18279013cla_ques
claqueurs20262063claqueurs
claroes93113733claro_es
claros84015113claro__s
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313913clatters
clavers124314903cla_vers
claviers1367103claviers
clavus11347353cla_vu_s
clawers123910973cla_wers
claxons1635803claxo_ns
claymore1544253claymo_re
claymores1644273claymores
climbers14318413climbers
clouds94612353cl__ouds
clour76617283cl__our_
clouts87017203cl__outs
clumbers143910413clumbers
colours95913443c_olours
comous10816503c_omou_s
concours1239473concours
contours1039653contours
cormous11312353cormou_s
crammers14369353crammers
cymous1388403c_ymou_s
enamors939123enamo_rs
enamour945433enamour_
famous11412393_famou_s
favours13437093_favours
flameouts1443923flameouts
flamers124616363flam_ers
flaneurs1133953flaneurs
flavors1337293flavo_rs
flavour1334633flavour_
flavoury1743063flavoury
flours94414053fl__ours
giaours834573gia_ours
glamor958183glamo_r_
glamoured1343183glamoured
glamourous1352353glamourous
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 9 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.453394461.4
2DLD Change Limit1461621327.79618748.3
3Display Results1321320.0462869.6
 (SQL Overall)1786911328.29521542.0
 
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.