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
clamours125596(None) 
clamors11710091clamo_rs
clamour1196321clamour_
glamours1184721glamours
amours83512642__amours
clambers144211282clambers
clammers143510682clammers
clamor1049452clamo_r_
clamorers1345782clamorers
clamoured1444062clamoured
clampers143211882clampers
clangours12263112clangours
clours85215082cl__ours
enamours1044652enamours
flavours1434682flavours
glamors1068112glamo_rs
glamour1065132glamour_
labours9349882_labours
agamous1037923agamou_s
alamodes1148013alamodes
alamos8415003alamo__s
amour75014853__amour_
armours9389843_armours
beclamors1574223beclamo_rs
beglamours1591823beglamours
belabours1343533belabours
blamers115314213blam_ers
calamars1238133calam_ars
calamus1139243calam_u_s
callous93516593callou_s
cambers134017433c_ambers
camorra11115763c_amorra
camorras12116493c_amorras
camos95927613c_amo__s
campers134220283c_ampers
campouts1436823c_ampouts
campus125213923c_ampu_s
candours11408613candours
canoers94318373c_anoers
chabouks1943813chabouks
chadors1338723chado_rs
chambers173410613chambers
chamfers18409213chamfers
chamois143512173chamo_is
champers173311613champers
chymous1775693chymou_s
clabbers14359893clabbers
clackers163911703clackers
cladodes1245323cladodes
clafouti1342903clafouti
clafoutis1442223clafoutis
claimers12298743claimers
clamber133311733clamber_
clammer134211793clammer_
clamored1336943clamored
clamorer1236903clamorer
clamorous1346193clamorous
clamouring15104763clamouring
clamper134012993clamper_
clamps124515083clam__ps
clams95127673clam___s
clamworm1744193clamworm
clamworms1843733clamworms
clangers114312343clangers
clangors11417003clangors
clangour11293803clangour_
clappers143310833clappers
claquers19226193claquers
claques18279013cla_ques
claqueurs20262063claqueurs
claroes93113733claro_es
claros84015113claro__s
clashers134213993clashers
claspers124410913claspers
classers104111833classers
clatters103313903clatters
clavers124314893cla_vers
claviers1367103claviers
clavus11347353cla_vu_s
clawers123910963cla_wers
claxons1635803claxo_ns
claymore1544253claymo_re
claymores1644273claymores
climbers14318403climbers
clouds94612353cl__ouds
clour76617283cl__our_
clouts87017203cl__outs
clumbers143910393clumbers
colours95913413c_olours
comous10816503c_omou_s
concours1239433concours
contours1039613contours
cormous11312353cormou_s
crammers14369343crammers
cymous1388403c_ymou_s
enamors939123enamo_rs
enamour945433enamour_
famous11412393_famou_s
favours13437083_favours
flameouts1443923flameouts
flamers124616363flam_ers
flaneurs1133953flaneurs
flavors1337293flavo_rs
flavour1334633flavour_
flavoury1743063flavoury
flours94414053fl__ours
giaours834563gia_ours
glamor958183glamo_r_
glamoured1343183glamoured
glamourous1352353glamourous
humours1286413_humours
labors84016403_labo_rs
labour84210933_labour_
lambers113817103_lambers
lampers113817333_lampers
langurs889103_langurs
layouts1046483_layouts
lemurs837253_lem_urs
lours55125293_l__ours
paramours1345643paramours
ramous8417103_ramou_s
rumours976363_rumours
samburs11369343_samburs
sapours93610613_sapours
savours10389333_savours
slammers123511223slammers
tabours94110073_tabours
tambours1255863_tambours
tamburs11288603_tamburs
tumours976733_tumours
valours10248733_valours
vapours12277453_vapours

Search took 10 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.1731032896.0
2DLD Change Limit1461621329.18615911.4
3Display Results1321320.0462869.6
 (SQL Overall)1786911329.40518999.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.